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:

UPC SKU COST Price DESCRIPTION MSRP 20892002043 WNX123MXCT6-RSR 13.38 16.73 Winchester Ammunition Supreme Double X Magnum Turkey, 12 Gauge, 3", #6 , 2 oz., Shotshell X123MXCT6 19.95 20892002043 AX123MXCT6-ZND 13.97 17.46 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 19.95 <colgroup><col><col><col><col><col><col></colgroup><tbody> </tbody> <colgroup><col><col><col><col><col></colgroup><tbody> </tbody>
​

<colgroup><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>

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