Getting address from Large() result

[Guest]

Is there a way to get the address info from the result of
a large() function. I want to information from another
column based on numerical rank. Since some of the values
are the same, I can't simply use vlookup.

 

[Frank Kabel]

Hi
try something like
=VLOOKUP(LARGE(A1:A100,2),A1:B100,2,0)

 

[Guest]

But won't this fail if there are repeated values returned
by large()? For example if I have the following values:
1 A 8
2 B 10
3 C 11
4 D 11
5 E 15

wouldn't the vlookup always return "C" when looking up the
value 11?

 

[Frank Kabel]

Hi
yes it would. If you want to prevent this try the following array
formula (entered with CTRL+sHIFT+ENTER):
=INDEX($B$1:$B$100,MATCH(LARGE($A$1:$A$100+ROW($A$1:$A$100)/1000,2),$A$
1:$A$100+ROW($A$1:$A$100,0))

 

[Aladin Akyurek]

But won't this fail if there are repeated values returned
by large()? For example if I have the following values:
1 A 8
2 B 10
3 C 11
4 D 11
5 E 15

wouldn't the vlookup always return "C" when looking up the
value 11?

Are you attempting to construct a list of Top N items, like Top 3 stores,
based on their prices?