One way:
=index(a1:a4,match(max(b1:b4),b1:b4,0))

Adjust your ranges to match.

nicgendron wrote:

Hi, all,

I have something like this :

a 1
b 4
c 5
d 3

I'm doing a max function in the number column and it returns me '5'

But, after that, I want to know the letter which corresponds to the max
number

How can I do that?

Thanks

Nic

--
nicgendron
------------------------------------------------------------------------
nicgendron's Profile: http://www.excelforum.com/member.php...o&userid=25151
View this thread: http://www.excelforum.com/showthread...hreadid=386417

--

Dave Peterson