Lookup

[George777]

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(G2Q2)...the dates go from G1Q1. 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.

 

[T. Valko]

Try this:

=INDEX(G$1Q$1,MATCH(MAX(G2Q2),G2Q2,0))

Format as Date

 

[smartin]

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(G2Q2)...the dates go from G1Q1. 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(G1Q1,1,MATCH(MAX(G2Q2),G2Q2,0))