First time posting here. I am an Excel novice and having trouble figuring out how to do something.
I have two spreadsheets: 1) A product list that contains SKU#s and product details and 2) a price list that contains SKU#s, prices and inventory.
Spreadsheet 2, the price one, has 180,000 products, the products list has 8000. I need to be able to find the rows in the price list with the same SKUs as the product list and then extract the price data so I can add it to the product list.
How would I do this?
I have not tried anything as I don’t know where to start.
New contributor
Andrew van Laar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.