Value in cell adjacent to max of column

D

dauclair

I want to be able to grab a value in a row adjacent to the maximum of
another column. If the maximum value of column C was in row 30, I want
to be able to return the value of cell A30.

Any help would be greatly appreciated.
 
H

Hans Knudsen

=INDEX($A$1:$A$40,MATCH(MAX($C$1:$C$40),$C$1:$C$40,0)) entered as array formula (hold down Ctrl and Shift while pressing Enter).

Regards
Hans
 
Top