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.

Try this:

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

HTH,

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


"robh_2" wrote in message
...
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.

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

"RagDyer" wrote:

Try this:

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

HTH,

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


"robh_2" wrote in message
...
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.

Appreciate the feed-back.
--

HTH,

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

"robh_2" wrote in message
...
Thank you very much..I was able to make your suggestion work.

"RagDyer" wrote:

Try this:

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

HTH,

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


"robh_2" wrote in message
...
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.