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))
|