Some extra clarifying info for this thread
https://excelfox.com/forum/showthrea...tiple-Criteria
and specifically this post
https://excelfox.com/forum/showthrea...5048#post15048

For this range with Helper column



_____ Workbook: AllFormulasAndVBAMultipleCriteria.xlsm ( Using Excel 2007 32 bit )
Row\Col A B C D E F
1 Sales Man Territory Dimension Helper Column Sales Amt Cost
2 John New York Tissue John|New York|Tissue 1,000.00 200.00
3 Alfred Washington Soda Alfred|Washington|Soda 2,100.00 700.00
4 John New York Soda John|New York|Soda 2,050.00 1,500.00
5 Alfred New York Tissue Alfred|New York|Tissue 2,000.00 500.00
6 Leo Washington Soda Leo|Washington|Soda 200.00 100.00
7 Leo New York Tissue Leo|New York|Tissue 3,500.00 1,500.00
8 Maxwell Washington Towel Maxwell|Washington|Towel 1,000.00 800.00
Worksheet: Export

_____ Workbook: AllFormulasAndVBAMultipleCriteria.xlsm ( Using Excel 2007 32 bit )
Row\Col
D
1
Helper Column
2
=A2&"|"&B2&"|"&C2
3
=A3&"|"&B3&"|"&C3
4
=A4&"|"&B4&"|"&C4
5
=A5&"|"&B5&"|"&C5
6
=A6&"|"&B6&"|"&C6
7
=A7&"|"&B7&"|"&C7
8
=A8&"|"&B8&"|"&C8
Worksheet: Export



Formula VLookUp

_____ Workbook: AllFormulasAndVBAMultipleCriteria.xlsm ( 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: ResultVLookUp


Formula Index

_____ Workbook: AllFormulasAndVBAMultipleCriteria.xlsm ( Using Excel 2007 32 bit )
Row\Col
D
E
2
=IF(ISERROR(INDEX(Export!$E$2:$E$8,MATCH(1,(ResultIndex!A2=Export!$A$2:$A$8)*(ResultIndex!B2=Export!$B$2:$B$8)*(ResultIndex!C2=Export!$C$2:$C$8),0),1)),"",INDEX(Export!$E$2:$E$8,MATCH(1,(ResultIndex!A2=Export!$A$2:$A$8)*(ResultIndex!B2=Export!$B$2:$B$8)*(ResultIndex!C2=Export!$C$2:$C$8),0),1))
=IF(ISERROR(INDEX(Export!$F$2:$F$8,MATCH(1,(ResultIndex!A2=Export!$A$2:$A$8)*(ResultIndex!B2=Export!$B$2:$B$8)*(ResultIndex!C2=Export!$C$2:$C$8),0),1)),"",INDEX(Export!$F$2:$F$8,MATCH(1,(ResultIndex!A2=Export!$A$2:$A$8)*(ResultIndex!B2=Export!$B$2:$B$8)*(ResultIndex!C2=Export!$C$2:$C$8),0),1))
Worksheet: ResultIndex

_____ Workbook: AllFormulasAndVBAMultipleCriteria.xlsm ( Using Excel 2007 32 bit )
Row\Col
D
E
2
=IFERROR(INDEX(Export!$E$2:$E$8,MATCH(1,(ResultIndex2!A2=Export!$A$2:$A$8)*(ResultIndex2!B2=Export!$B$2:$B$8)*(ResultIndex2!C2=Export!$C$2:$C$8),0),1),"")
=IFERROR(INDEX(Export!$F$2:$F$8,MATCH(1,(ResultIndex2!A2=Export!$A$2:$A$8)*(ResultIndex2!B2=Export!$B$2:$B$8)*(ResultIndex2!C2=Export!$C$2:$C$8),0),1),"")
Worksheet: ResultIndex2