PDA

View Full Version : Solved: Some Sort of Lookup?



Eric58132
02-17-2009, 12:33 PM
Hi Everyone,

Thank you in advance for any sort of suggestion/solution you can provide for me.

I have what I would describe as a crosstab table with dates on one axis and locations on another. Dates are on the X, locations on Y. I'm trying to pull data from this table into another "table", whenever the dates match. For example, I want my expression to say "take this provided date, look for where it appears in the table, and then give me the value which lies 4(used as example) rows below." If at all possible, I would prefer to use excel functions as opposed to VBA.

Again, thank you for your help.

MaximS
02-17-2009, 12:44 PM
try formula used in attachment.

mdmackillop
02-17-2009, 12:46 PM
Hi Eric
Welcome to VBAX,
If you can post a small sample showing just what you are after it makes life easier. Use Manage Attachments in the Go Advanced reply section
Regards
MD

Eric58132
02-17-2009, 01:05 PM
Thank you both for your timely responses. Maxim, I had a little bit of trouble deciphering your response so I built an example as suggested. I'm looking to populate the bottom table into the top one. I hope this makes things more clear. Thanks again.

mdmackillop
02-17-2009, 01:53 PM
Use Maxim's formula in B2, copy across and down.
=OFFSET($B19,0,MATCH(B$1,$C$18:$L$18,0),1,1)

Eric58132
02-17-2009, 02:04 PM
Works Great! Thank you for taking the time to help me. I'll change this thread to solved