Hello. I have a list of inventory skus that have purchase transactions across the columns. I want to be able to grab the corresponding price into the sales numbers for each year. There is no matching year, but rather the inventory just runs down from left (on the top table) to right. In cells C8, I've calculated the correct COGS but I wanted to know how I can create a lookup formula that grabs the correct price for the units for all the skus. Spreadsheet attached.
Bookmarks