I have 2 excel spreadsheets, A and B. Each contain products that have prices.
I need to update one of the spreadsheets (A) with the prices from the other
(B). Here is the problem, spreadsheet A has 500 products and spreadsheet B
has 1000 products. I only to update the prices based on the 500 products in
spreadsheet A. In other words, have excel search through spreadsheet B (1000
products) and update spreadsheet A (500 products) prices.
Any recommendations?

Thanks.