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:
<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
<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