Value in cell adjacent to max of column

[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.

[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


"dauclair" <dauclair.28fe4q_1148665251.6969@excelforum-nospam.com> skrev i en meddelelse
news:dauclair.28fe4q_1148665251.6969@excelforum-nospam.com...
>
> 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.
>
>
> --
> dauclair
> ------------------------------------------------------------------------
> dauclair's Profile: http://www.excelforum.com/member.php...o&userid=34852
> View this thread: http://www.excelforum.com/showthread...hreadid=545973
>