I am trying to lookup up a specific "item code " if available from the table based on the parameters provided. not sure if multiple vlookups formulas required here?
SKU Status Year ITEM CODE
581 STOCK 2014 ?
828 STOCK 2018 ?
854 OUT 2016
927 ORDER 2018
217 STOCK 2017
Bookmarks