Try to explain the best I can.
First sheet is called 'Products', and the second sheet is called 'Products List'.
In Sheet: Products
Column A is Products and Column B is the UPC of that product, and a 3rd column let's say it will be unique each time.
In Sheet: Products List
Column A is the description of the product, and column B will be the product UPC.
So basically in sheet 'Products List' they will enter a UPC of a product in column b, and in column a give it a unique name.
Now what I would like sheet 'Products' to do is when they enter a UPC in column B, it would look at the column B in the Products List sheet and if that matches, grab the name of whatever is in column A.
The Products sheet might have like 20 of the same UPC's where in Column C they will enter unique ifo for that particular product.
I tried vlookup, but I don't think that worked that well. Hopefully someone can help.
Here's a sample: https://docs.google.com/spreadsheets...it?usp=sharing
Please note the second sheet 'Products List' will only have one UPC per description. And the 'Products' will have a lot of the same UPC's but with a 3rd column.
Bookmarks