Is there a way to get the address of the cell with the Max of a range?

[TomCon]

Actually, I want to get an offset from the cell that has the Max value of a range.

I need a formula that can do this:
The cell value should equal the value two columns to the right, in the same row, of the cell that has the Max of a range.

For Example, if A1:A5 contains: 4,6,2,3,1, then A2 contains Max(a1:a5), and so i want the value two columns to the right of A2, or in other words, the value in C2, to be returned.

Note, if the Max is not unique it would be fine to return the first occurance.

Thanks!
Tom

 

[Marcelo Branco]

Maybe

=INDEX(C1:C5,MATCH(MAX(A1:A5),A1:A5,0))

HTH

M.

 

[TomCon]

Indeed so! Thanks much! Sometimes you forget how to string all these together correctly!
Tom

 

[Marcelo Branco]

Indeed so! Thanks much! Sometimes you forget how to string all these together correctly!
Tom

You are welcome and tks for the feedback

M.