function to find name related to highest value

i have six cells with six names . each cell (with its name) has got a value in a near cell.

for example (consider each letter is a cell and each number/value is a cell):

a 1
b 2
c 3
d 4
e 5
f 6

i want to find a function that writes, in another cell, the name of the cell whose near cell has got the highest value.

in the case above, it would be "f".

i don't know if i explained myself well

thanks for any help !

Originally Posted by VBA Noob

Does this help

=INDEX(A1:A6,MATCH(MAX(B1:B6),B1:B6,0))

VBA Noob

are you sure ? because it gives me error ... is the final 0 ok ?

thanks !

Originally Posted by VBA Noob

Worked for me

VBA Noob

I WILL TRY , thanks !

also, can't i do it with the LOOKUP function ?

i tried =LOOKUP(MAX,A1:A6,B1:B6) but it does not work ..

Take a look at Help for VLOOKUP, and you'll see why it can't work for this.

I have also the same problem but in this problem i want to fint the top three value names.
can any one help me?

Originally Posted by hoopes

i have six cells with six names . each cell (with its name) has got a value in a near cell.

for example (consider each letter is a cell and each number/value is a cell):

a 1
b 2
c 3
d 4
e 5
f 6

i want to find a function that writes, in another cell, the name of the cell whose near cell has got the highest value.

in the case above, it would be "f".

i don't know if i explained myself well

thanks for any help !

Eg:
Name nO.OF DAYS PRESET
ABCD 30
EFGH 30
IJKL 20
MNOP 22
I WANT THE NAME OF HIGHEST NUMBER OF DAYS PRESET... IN THIS 30 TWICE HOW TO DISPLAY THE TWO NAMES?

Ok thanks