How to get a value from another sheet by satisfying multiple criteria. Vlookup takes only one criteria for lookup function. If or e.g., 3 criteria has to be checked and bring a value from another sheet what is the formula to use.
Sheet 1 - Parts summary: where i need to bring in car volume from sheet no.2. for each and every part numbers that supplied
Customer MODEL EXP/DOM EMPOWER PART NO PART NO. PART NAME 2010
Hyundai EMXI Domestic SCH00101000 60063003 B376 TEXTURED SCALP LH
Hyundai EMXI Domestic SCH00201000 60063004 B376 TEXTURED SCALP RH
Hyundai EMXI Domestic SCH00301000 60061001 B376 CASE REAR LH
Sheet 2 - Has car volume for all OEM's.
BRAND CODE DOM/EXP 2010 2011 2012
Hyundai MXI Domestic 60000 54000 48600
Hyundai Atos EMXI Export 20000 18000 16200
Hyundai Accent LCI Domestic 7000 6300 5670
Hyundai Verna MCI Domestic 1000 900 810
Sheet 1 - Parts summary: where i need to bring in car volume from sheet no.2. for each and every part numbers that supplied
Customer MODEL EXP/DOM EMPOWER PART NO PART NO. PART NAME 2010
Hyundai EMXI Domestic SCH00101000 60063003 B376 TEXTURED SCALP LH
Hyundai EMXI Domestic SCH00201000 60063004 B376 TEXTURED SCALP RH
Hyundai EMXI Domestic SCH00301000 60061001 B376 CASE REAR LH
Sheet 2 - Has car volume for all OEM's.
BRAND CODE DOM/EXP 2010 2011 2012
Hyundai MXI Domestic 60000 54000 48600
Hyundai Atos EMXI Export 20000 18000 16200
Hyundai Accent LCI Domestic 7000 6300 5670
Hyundai Verna MCI Domestic 1000 900 810