ExcelBanter - VLOOKUP??

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - VLOOKUP?? (https://www.excelbanter.com/excel-worksheet-functions/129032-vlookup.html)

I have three sheets of information. In Sheet A, for cell A1, I have
to first go to Sheet B, cell B1 to find a date. From here, I need to
go to Sheet C, column A, and FIND that date, then go across that row
and return to Sheet A, cell A1, what the value found in cell AA on the
row of Sheet C for the date in question. Any help?

I think this is what you want to put in cell A1 on sheet 1
=VLOOKUP(Sheet2!B1,Sheet3!A1:AA10,27)
for the data on sheet 3 you will need put in the correst range for the
number of rows (ie change A1:AA10)
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

"Titanus" wrote:

I have three sheets of information. In Sheet A, for cell A1, I have
to first go to Sheet B, cell B1 to find a date. From here, I need to
go to Sheet C, column A, and FIND that date, then go across that row
and return to Sheet A, cell A1, what the value found in cell AA on the
row of Sheet C for the date in question. Any help?