Vlookup and Large Function Not Return Correct Values

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

"Helper" column in E

in E2

=B2+(COUNTIF($B$2:B2,B2)-1)*0.01

copy down

in D2

=INDEX($C$2:$C$5,MATCH(LARGE($E$2:$E$5,ROWS($1:1)),$E$2:$E$5,0))

copy down

Thanks John for your quick reply, but when I pasted your formula in E2, I got #VALUE!, what is the problem here?

See attached.

Thanks John again, I saw attached example before and still didn't figure out how to solve my problem. My really task is to auto track Top 4 Downtime (DT) Minutes (Min) and display according DT Reason on daily basis. The DT records could reach 60 a day, and there could be same DT min with different reasons.

To simplify the case, I just use following 6 records as example, and I want to return top 4 DT min with according DT reasons:


Downtime Min Downtime Reason
10 Machine
20 Robot
10 Network
10 Sensor
5 Human Error
8 Fixture

Using my formula above, results returned:

20 Robot
10 Machine
10 Machine
10 Machine

What I want to see is:

20 Robot
10 Machine
10 Network
10 Sensor

Any help would be greatly appreciated!

Kevin

Sorry but I don't see why it is so difficult (you can't have used my formulae) ... see attached

Thanks so much John for your help, your approach and formula works great!!!