Using INDEX to find the match
 

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

Using INDEX to find the match
 

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

HTH
--
AP

"harshaputhraya"
<harshaputhraya.27j9ez_1147166101.5998@excelforu m-nospam.com a écrit dans
le message de news:
...

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