Lookup
 

I have numbers going across the rows with the date in row 1. To the
right of my data, I have a function finding the max value in that row
max(G2:DQ2)...the dates go from G1:DQ1. Now, what I want to do is
return the corresponding date to that max number in another cell. So,
if the max number is in cell DQ2, then I want it to return the date in
DQ1.

Any help would be greatly appreciated.

Lookup
 

Try this:

=INDEX(G$1:DQ$1,MATCH(MAX(G2:DQ2),G2:DQ2,0))

Format as Date

--
Biff
Microsoft Excel MVP


"George777" wrote in message
...
I have numbers going across the rows with the date in row 1. To the
right of my data, I have a function finding the max value in that row
max(G2:DQ2)...the dates go from G1:DQ1. Now, what I want to do is
return the corresponding date to that max number in another cell. So,
if the max number is in cell DQ2, then I want it to return the date in
DQ1.

Any help would be greatly appreciated.

Lookup
 

George777 wrote:
I have numbers going across the rows with the date in row 1. To the
right of my data, I have a function finding the max value in that row
max(G2:DQ2)...the dates go from G1:DQ1. Now, what I want to do is
return the corresponding date to that max number in another cell. So,
if the max number is in cell DQ2, then I want it to return the date in
DQ1.

Any help would be greatly appreciated.

Try:

=INDEX(G1:DQ1,1,MATCH(MAX(G2:DQ2),G2:DQ2,0))