T
Titanus
Okay, so here's my problem:
I want to fill in cells of Sheet A by referencing values from two
other sheets. Sheet B has the date for the data that I want to use.
However, Sheet C has the data I need.
So, what I want to do is the following:
In Cell A1 of Sheet A, for the date listed in Cell B1 of Sheet B, find
the corresponding date in Column A of Sheet C, then go across that row
and for a particular cell where the heading at the top of THAT column
is equal to X, return to A1 of Sheet A that value.
It's a combo of VLOOKUP and HLOOKUP, right? I just can't seem to make
it work, though.
I want to fill in cells of Sheet A by referencing values from two
other sheets. Sheet B has the date for the data that I want to use.
However, Sheet C has the data I need.
So, what I want to do is the following:
In Cell A1 of Sheet A, for the date listed in Cell B1 of Sheet B, find
the corresponding date in Column A of Sheet C, then go across that row
and for a particular cell where the heading at the top of THAT column
is equal to X, return to A1 of Sheet A that value.
It's a combo of VLOOKUP and HLOOKUP, right? I just can't seem to make
it work, though.