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.
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.