I have 2 different sheets(see attachments. The Inventory Sheet has a list of our items and our cost, but we have a list from our supplier that they sent us with some updated prices. We are in the process of changing item numbers to match the list from the specific supplier, since we are now only making purchases from them. I need a solution to match any items from the 2 lists and change it to the new price. if the item does not match the to leave the price. By the way I'm really new to excel so if you can give me the Dummys explanation.
Bookmarks