Index/Match using Large Formula

[Steve0492]

Hello,

I have a list of names and associated numbers. I want to use the following to return the descriptor of the nth largest number:

=INDEX(A8:A10,MATCH(LARGE(B8:B10,1),B8:B10))

However, the formula seems to return the last value in the data set. I believe the error is somewhere in the Match function.

I have attached an example workbook with a mock data set that is representative of my larger and actual one. Thanks for the help!

Steve

[Ace_XL]

You need an exact match.. hence use

=INDEX(A8:A10,MATCH(LARGE(B8:B10,1),B8:B10,0))

[:) Sixthsense :)]

You are missing the last argument of match function

=INDEX(A8:A10,MATCH(LARGE(B8:B10,1),B8:B10,0))

[Steve0492]

Bingo! Thanks Ace.

You've certainly moved up in prestige quickly. I recall when you first began contributing ~1 year ago in the VBA forums