Hi, below first two columns is raw data set, I am trying to return Item value based on QTY.


QTY Item results returned Formula results desired
20 Orange Orange =VLOOKUP(LARGE(B3:B6, 1),B3:C6, 2, FALSE) Orange
10 Apple Apple =VLOOKUP(LARGE(B3:B6, 2),B3:C6, 2, FALSE) Apple
10 Watermelon Apple =VLOOKUP(LARGE(B3:B6, 3),B3:C6, 2, FALSE) Watermelon
8 Kiwi Kiwi =VLOOKUP(LARGE(B3:B6, 4),B3:C6, 2, FALSE) Kiwi

Since there are two 10s in QTY, Apple is the first item on item list with QTY 10, so excel returns Apply twice. How can I get the results desired, which is Apple for first 10, and Watermelon for second 10, instead of results returned? Thanks very much for your help in advance.

Kevin