I am trying to determine if somehow I can use the contents of a cell
contining a date to satisfy the result_vector argument in the function
LOOKUP(lookup_value,lookup_vector,result_vector), and if so how?
I have a spreadsheet (Sheet1) that has say 10
rows (1-10) of data in 15
columns (A-O). I have column labels in Row 1. Column A is labelled FName.
Columns B through O are labelled with dates (note:Cell B1 has a specific date
and cells C1:O1 are then calculated dates based on cell B1).
My issue: I wish to make a small report on a separate
sheet (Sheet2) that
will populate the report with data from Sheet1 once I enter a valid name and
a valid date on my report in Sheet2. For example: If I enter Bob in cell
Sheet2!A1 and and a valid date in cell Sheet2!B1, I was hoping that in new
cell Sheet2!A2 I could use the LOOKUP function to retrieve the contents from
Sheet1 at the intersection of Bob and the date I have inserted in cell
Sheet2!B1. The LOOKUP function accepts the contents of cell Sheet2!A1 as a
valid argument for lookup_value, and I have given a name to cells
Sheet1!A2:A9 and used it to satisfy the argument for look_up vector, and
these both work fine. I cannot seem to figure out how to get the contents of
cell Sheet2!B1 to satisfy the result_vector argument and thus return the
contents from the corresponding cell in Sheet1. Any suggestions would be
greatly appreciated. Thank you.