Searching and finding
 

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.

Searching and finding
 

Try this:

=VLOOKUP('Sheet B'!B1,'Sheet C'!A2:F20,MATCH("X",'Sheet C'!A1:F1,0),0)

Biff

"Titanus" wrote in message
oups.com...
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.