List Top 3 Text & Values?

[ttamvegas]

I have a large list with text of item names in column A and their values in column B.

I used =LARGE(B3:B43, 1) =LARGE(B3:B43, 2) =LARGE(B3:B43, 3)
to find the Top 3 values and it works fine, however I want to bring the Item name from column A as well not just the value. How would I do this? thanks!

 

[JackDanIce]

Welcome to the board.
Try:

=OFFSET(INDIRECT("B"&LARGE(B3:B43,1)),0,-1)
=OFFSET(INDIRECT("B"&LARGE(B3:B43,2)),0,-1)
=OFFSET(INDIRECT("B"&LARGE(B3:B43,3)),0,-1)

 

[Andrew Poulsom]

Try eg:

=INDEX(A3:A43,MATCH(LARGE(B3:B43,1),B3:B43,FALSE))

 

[Dryver14]

try this

=LARGE(B3:B9,1)&" "&INDEX(A3:A9,MATCH(LARGE(B3:B9,1),B3:B9,0))

 

[kennycwhite]

With respect to the equation below, if there are duplicate values in B:B it returns the same values for as many duplicates as there are. So if the 4th largest and 5th largest in B:B are the number 3 then it currently returns the same thing for 4th largest and 5th largest although the values in A:A are different. It will then return the correct value for the 6th largest. It doesn't matter which one it returns as 4th or 5th, I just need it to return both values separately. There will be an unknown number of duplicates in B:B, I am focusing on grabbing the 10 largest values along with the value in the corresponding A column. I tried to attach as screenshot, hopefully it works so you can see what the results are yielding.

=LARGE(B:B,1)&" "&INDEX(A:A,MATCH(LARGE(B:B,1),B:B,0))