Lookup

G

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(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.
 
S

smartin

George777 said:
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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top