Searching and finding

  • Thread starter Thread starter Titanus
  • Start date Start date
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.
 
Try this:

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

Biff
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update cell value based on name and specific date 1
Vlookup and return sheet name also 2
Creating a dynamic IF statement 2
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
using vlookup to find data outside a specified range 1
Need VLOOKUP to Work Two Ways 0
Copy corresponding cell in Column B if cell in A contains certain text? 1
Figuring out a lengthy formula. Probably quite simple... 3

Back
Top