One way:

=INDEX(A1:A4,MATCH(MAX(B1:B4),B1:B4,0))

Note that if there are multiple instances of the max value the formula will
"find" the 1st instance from the top.

--
Biff
Microsoft Excel MVP


"Sungibungi" wrote in message
...
Hey all,

I have a question regarding extractingt the row of the maximum number in a
list and referencing the cell next to it..
For instance,

A B
1 Data1 12
2 Data2 13
3 Data3 18
4 Data4 17

I want to find the maximum in column B (18) and display the A column
(Data3). It seems simple but I can't seem to do it for some reason.

Thanks for all the hope in advance.