Multiple VLookup Criteria

[martialtiger]

Hi Guys,

I was wondering if anyone can tell me how I would be able to get the corresponding value of a cell on another sheet within the same workbook based on 2 values.

Here are the datasets on my 2 sheets.

sheet1

YEARMON	SOURCEKEY	RECIPIENTS	DELIVERED
201003	MDER9E01A	127	104
201003	MDER9E01B	128	106
201003	MDEVXE01A	457	324

sheet2

YEARMON	SOURCEKEY	CAMPAIGN	ORDERS	GROSS	GROSSAVG
201003	MDEVXE01A	INTEML	1	136.6	136.6
201003	PDER9E01A	INTEML	1	78.35	78.35
201003	PDEVXE01A	INTEML	1	50.74	50.74
201003	PDEVXE01B	INTEML	1	76.85	76.85
201003	PDEVYE01A	INTEML	1	0	0
201003	VXER9E01A	INTEML	8	485.99	60.75
201003	VXER9E01B	INTEML	6	300.33	50.06

What I want to do is add another column in sheet 1 labeled campaign and insert the appropriate value found in sheet2 that matches the YEARMON & SOURCEKEY values on sheet1 to sheet2. Hope that makes sense.

TIA

 

[Andrew Poulsom]

Try eg:

=INDEX(Sheet2!C:C,MATCH(1,INDEX((Sheet2!A:A=A2)*(Sheet2!B:B=B2),),FALSE))