Hello all,
Fairly new using index match with excel. I've had success in the past, but it was a simpler formula. What I am trying to do is the following:
Using "BPO Open Order Report" column "C" + "D" to look up against "Warehouse Receipts Report" where column "B" + "C" will pull in the various fields i need. I think my issue with the formula is that I am trying to concatenate within the formula instead of creating a separate column with the concatenation.
The formula is in "BPO Open Order Report" in "O2", also posted here in case its a formatting issue.
=INDEX('Warehouse Reciepts Report'!B2:H7,MATCH(C2&D2,'Warehouse Reciepts Report'!B2&'Warehouse Reciepts Report'!C2,0),2)
Bookmarks