search a row to find the column
 

Here's what I need to do.

I have two sheets, I need the one sheet to reference the other, search for a
certain date in a known row, find out what column it is in, and retrieve a
number associated with the date in a second known row and the column we found.

Here's the relevant data:
The date on sheet 1 is in cell A1
It has to search for that date on sheet 2 in row 8
Then it retrieves the information in the cell located in whatever column we
find, row 47 on sheet 2
And posts it to sheet 1, cell c4

I am lost, please help.

Take a look at Excel's help file for examples of LOOKUP() & HLOOKUP() functions

"Stephen" wrote:

Here's what I need to do.

I have two sheets, I need the one sheet to reference the other, search for a
certain date in a known row, find out what column it is in, and retrieve a
number associated with the date in a second known row and the column we found.

Here's the relevant data:
The date on sheet 1 is in cell A1
It has to search for that date on sheet 2 in row 8
Then it retrieves the information in the cell located in whatever column we
find, row 47 on sheet 2
And posts it to sheet 1, cell c4

I am lost, please help.

Try this in C4 of Sheet1:

=INDEX(Sheet2!A47:Z47,MATCH(A1,Sheet2!A8:Z8,0))
--

HTH,

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


"Stephen" wrote in message
...
Here's what I need to do.

I have two sheets, I need the one sheet to reference the other, search for a
certain date in a known row, find out what column it is in, and retrieve a
number associated with the date in a second known row and the column we
found.

Here's the relevant data:
The date on sheet 1 is in cell A1
It has to search for that date on sheet 2 in row 8
Then it retrieves the information in the cell located in whatever column we
find, row 47 on sheet 2
And posts it to sheet 1, cell c4

I am lost, please help.