Kagzfirearms
New Member
- Joined
- Nov 15, 2018
- Messages
- 5
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="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
[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