I have a company "master" product list that contains roughly 4,100 items, ("For Freelancer" tab). I need to extract the corresponding "List" prices from the price schedules of nine manufacturers (Husky, OPW, etc). They need to be displayed in the "List" column of the master list. I will also need a list of the items (from the master list) for which no corresponding list price was found. You will need to pull from multiple sheets (of the workbook) for some manufacturers.
My master product list is named "QPS Master Items List [login to view URL]"