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 news:
harshaputhraya.27j9ez_1147166101.599...rum-nospam.com...
>
> 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
>
>
> --
> harshaputhraya
> ------------------------------------------------------------------------
> harshaputhraya's Profile:
> http://www.excelforum.com/member.php...o&userid=33225
> View this thread: http://www.excelforum.com/showthread...hreadid=540177
>