VLOOKUP on Matching Multiple Criteria

[msiyab]

Example in uploaded file, VLookUpMultipleCriteria.xlsx
Your formula in row 2 to be copied down would be:
_____ Workbook: VLookUpMultipleCriteria.xlsx ( Using Excel 2007 32 bit )

Row\Col	D	E
2	=IF(ISERROR(VLOOKUP(A2&"|"&B2&"|"&C2,Export!$D$2:$F$8,2,FALSE)),"",VLOOKUP(A2&"|"&B2&"|"&C2,Export!$D$2:$F$8,2,FALSE))	=IF(ISERROR(VLOOKUP(A2&"|"&B2&"|"&C2,Export!$D$2:$F$8,3,FALSE)),"",VLOOKUP(A2&"|"&B2&"|"&C2,Export!$D$2:$F$8,3,FALSE))

Worksheet: Result

---

Alan

I used the Vlookup formula you provided here and it worked well. Will try out in our reports during the month end and will provide a feedback then.