Finding a certain value from a list of matching values

[Kagzfirearms]

So what i am doing is scanning barcodes, the only problem i have is that the barcodes on products are all the same. I have several distributors that supply the same products but at mostly different prices. I would like to be able to tell excell to find that product ( which i have already done but it returns the first found match in the fields ) and i can select from a list of the 5 or so distributors. Any way to do that? Below i have attached some examples:

[TABLE="width: 836"]
<colgroup><col><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD="align: right"][TABLE="width: 1074"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"][TABLE="width: 1146"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD="align: center"]UPC[/TD]
[TD="align: center"]SKU[/TD]
[TD="align: center"]COST[/TD]
[TD="align: center"]Price[/TD]
[TD="align: center"]DESCRIPTION[/TD]
[TD="align: center"]MSRP[/TD]
[/TR]
[TR]
[TD="align: center"]20892002043[/TD]
[TD="align: center"]WNX123MXCT6-RSR[/TD]
[TD="align: center"]13.38[/TD]
[TD="align: center"]16.73[/TD]
[TD="align: center"]Winchester Ammunition Supreme Double X Magnum Turkey, 12 Gauge, 3", #6 , 2 oz., Shotshell X123MXCT6[/TD]
[TD="align: center"]19.95[/TD]
[/TR]
[TR]
[TD="align: center"]20892002043[/TD]
[TD="align: center"]AX123MXCT6-ZND[/TD]
[TD="align: center"]13.97[/TD]
[TD="align: center"]17.46[/TD]
[TD="align: center"]12 Gauge -3" shell length -1125 fps velocity -Shot size 6-2 oz-Copper plated hard shot -Grex®buffering -Custom blended powders-Consistent, high-velocity payload[/TD]
[TD="align: center"]19.95[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: right"]

​

[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]

[/TD]
[/TR]
</tbody>[/TABLE]

So above we see that we have matching products, same UPC from different wholesalers. Is there a way to create a dropdown so that my VLOOKUP will select the row from the distributor i specify?

Secondly i would like to also see it return the lowest cost wholesaler, however that is not that necessary if i can select a wholesaler from the dropdown. TIA

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...n-value-list-matching-values.html#post5178346

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it.
Please be patient and do not attempt to post the question again.