Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding, searching, and comparing cells to another sheet | Excel Worksheet Functions | |||
finding "™‚" character in a worksheet | Excel Discussion (Misc queries) | |||
Finding a sum in a list of values | Excel Discussion (Misc queries) | |||
cell background color while searching through cells | Excel Discussion (Misc queries) | |||
finding 600 emails in a column | New Users to Excel |