Using INDEX to find the match

[harshaputhraya]

Hi,
I want to use INDEX to display the name for the maximum value

eg:

Name value

A 5.00
B 6.00
C 7.00
D 8.00
E 9.00
F 10.00


I want to display F as it has the maximum value(which i have got
through MAX function).
How would i achieve that?

Appreciate ur help

Harsha

 

[Ardus Petus]

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

HTH
--
AP

"harshaputhraya"
<[email protected]> a écrit dans
le message de (e-mail address removed)...