table formula question

**cyncarrier** · 06-27-2009, 12:52 PM

Hi.. need help for this

in my database... colum E have diff number in it and colum B have a name in it
Exemple:

A B C D E F
Lili 1
Mat 29
Jym 20

i trying to find a formula that will look in colum E, find the highess number, and give me the name associate to it in colum B.

Can someone help me?
Thank you

**DonkeyOte** · 06-27-2009, 12:53 PM

Use INDEX with MATCH/MAX

=INDEX(B:B,MATCH(MAX(E:E),E:E,0))

**cyncarrier** · 06-27-2009, 01:05 PM

and if i wanna use colum F also i guess i change all the "E" for "F" in your fomula?

**cyncarrier** · 06-27-2009, 01:06 PM

and if i wanna change the "E" for "F" in

=INDEX(B:B,MATCH(MAX(E:E),E:E,0))

it will look at colum f right?

**DonkeyOte** · 06-27-2009, 01:08 PM

Yes, the MATCH & MAX should reference the column in which the numerics appear, the INDEX column should be that from which you wish to retrieve the associated value.