Can I use the contents of a cell to satisfy the result_vector arg.

[Guest]

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.

 

[RagDyer]

Try this:

=INDEX(Sheet1!A1:O10,MATCH(A1,Sheet1!A1:A10,0),MATCH(B1,Sheet1!A1:O1,0))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


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.

 

[Guest]

Thank you very much..I was able to make your suggestion work.

 

[RagDyer]

Appreciate the feed-back.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Thank you very much..I was able to make your suggestion work.