LOOKUP VALUE

[datastudent]

Hi,

I want to look up the "ACTIVATION" and "DID MRC" value of the Country while considering the Number Type.

Table 1 is a sample source while table 2 is my main table.

Template_v1.xlsm
	H	I	J	K	L	M	N	O	P
1	Country	Number type	ACTIVATION	DID MRC		Country	Number type	ACTIVATION	DID MRC
2	ARGENTINA	Geographic	0	2.91		AUSTRIA	Geographic	0	0.78
3	AUSTRALIA	Geographic	0	1.04		AUSTRIA	National	0	0.78
4	AUSTRIA	Geographic	0	0.78		AUSTRALIA	Geographic	0	1.04
5	AUSTRIA	National	0	0.78		AUSTRALIA	National
6	BELGIUM	Geographic	0	0.32		BELGIUM	Geographic	0	0.32
7	BELGIUM	National	3.11	0.32		BELGIUM	National	3.11	0.32
VoxDID

Cell Formulas
Range	Formula
M3,M7,M5	M3	=M2

 

[etaf]

sorry i'm not following , what are your expected results

 

[datastudent]

sorry i'm not following , what are your expected results

Table 2 ACTIVATION and DID MRC is my expected results.

I want to lookup those 2 column from table 1.

 

[etaf]

=IFERROR(INDEX(J$2:J$7,MATCH($M2&$N2,$H$2:$H$7&$I$2:$I$7,0)),"")

Book3
	H	I	J	K	L	M	N	O	P
1	Country	Number type	ACTIVATION	DID MRC		Country	Number type	ACTIVATION	DID MRC
2	ARGENTINA	Geographic	0	2.91		AUSTRIA	Geographic	0	0.78
3	AUSTRALIA	Geographic	0	1.04		AUSTRIA	National	0	0.78
4	AUSTRIA	Geographic	0	0.78		AUSTRALIA	Geographic	0	1.04
5	AUSTRIA	National	0	0.78		AUSTRALIA	National
6	BELGIUM	Geographic	0	0.32		BELGIUM	Geographic	0	0.32
7	BELGIUM	National	3.11	0.32		BELGIUM	National	3.11	0.32
Sheet1

Cell Formulas
Range	Formula
O2:P7	O2	=IFERROR(INDEX(J$2:J$7,MATCH($M2&$N2,$H$2:$H$7&$I$2:$I$7,0)),"")
M3,M7,M5	M3	=M2