How to extract top 5 values with display its adjacent cells values?

[sunying]

Column A=Location, Column=Percentage
my formula =Index($A$13:$A$40,Match(Large($D$13:$D$40+Rows($D$13:$D$40)/100,B2),$D$13:$D$40+Rows($D$13:$D$40)/100,0))
The formula doesn't work, it returns nothing but value error. I need to extract the top 5 values includes ties if any with display its adjacent cells values(location). Thank You.

[JohnTopley]

=INDEX($A$13:$A$40,match(large(D$13:$D$40,rows($1:1)),D$13:$D$40,0))
Entry with CtrL+Shift+Enter

Copy down

See Tony's post which accounts for duplicates.

[Tony Valko]

See this...

https://www.excelforum.com/showthread.php?p=3396886