How about...

=INDEX(A2:A6,MATCH(MAX(B2:B6),B2:B6,0))

That final 0 is very important.

DeeZi wrote:

Sorry, first-timer here.

ex:

A B
1 2
2 5
3 8
4 3
5 1

if I want to display the max of B, I would do =max(B1:B5). But I want
the A that corresponds to this which would be 3 (the max of B column is
8, corresponding to 3 from A column).

I tried :

=INDEX(A2:A6,MATCH(MAX(B2:B6),B2:B6))

but this doesn't work on other formulas (if my B column were formulas).
Does anyone know how to get it to work w/ formulas?

Thanks in advance

--
DeeZi
------------------------------------------------------------------------
DeeZi's Profile: http://www.excelforum.com/member.php...o&userid=24805
View this thread: http://www.excelforum.com/showthread...hreadid=383637

--

Dave Peterson