Hello all, good afternoon
Im looking for some help on matching 2 cells of data to show a value from a different sheet within the workbook. Currently i have the below formula to match a certain criteria and this works,
=INDEX('TREE BAG P+L'!A3:BA3,MATCH(VLOOKUP('TREE BAG P+L'!BB3,'SKU# DATA'!$B$1:$C$6,1,0),'TREE BAG P+L'!$A$2:$BB$2,0))
But what im trying to do now for example is
if A2 is C2 in sheet 1, then it needs to be "X cost" associated to those 2 values but match a different field
If you look at my example you can see what I'm indexing and see what I'm trying to achieve.
Thanks for your time
Bookmarks