Search Matching 2 keys

[lastminuteproject]

I'm trying several options but no one works. Let's see if anyone can help me.

I have a sheet with country information, like:

<table width="923" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64"> <col style="width: 76pt;" width="101"> <col style="width: 48pt;" width="64"> <col style="width: 46pt;" width="61"> <col style="width: 48pt;" width="64" span="3"> <col style="width: 55pt;" width="73"> <col style="width: 56pt;" width="74"> <col style="width: 55pt;" width="73"> <col style="width: 56pt;" width="74"> <col style="width: 55pt;" width="73"> <col style="width: 56pt;" width="74"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 48pt;" width="64" height="20">
</td> <td style="width: 76pt;" width="101">A</td> <td style="width: 48pt;" width="64">B</td> <td style="width: 46pt;" width="61">C</td> <td style="width: 48pt;" width="64">D</td> <td style="width: 48pt;" width="64">E </td> <td style="width: 48pt;" width="64">F</td> <td style="width: 55pt;" width="73">G</td> <td style="width: 56pt;" width="74">H</td> <td style="width: 55pt;" width="73">I</td> <td style="width: 56pt;" width="74">J</td> <td style="width: 55pt;" width="73">K</td> <td style="width: 56pt;" width="74">L</td> </tr> <tr style="height: 45.75pt;" height="61"> <td style="height: 45.75pt;" align="right" height="61">1</td> <td class="xl63" style="width: 76pt;" width="101">Country names </td> <td class="xl64" style="width: 48pt;" width="64">ISO 3166-1-alpha-2 code</td> <td class="xl63" style="width: 46pt;" width="61">International dial code </td> <td class="xl63" style="width: 48pt;" width="64">Start GMT </td> <td class="xl63" style="width: 48pt;" width="64">End GMT</td> <td class="xl65">Column1</td> <td class="xl65">Operator 1</td> <td class="xl65">MCCMNC1</td> <td class="xl65">Operator 2</td> <td class="xl65">MCCMNC2</td> <td class="xl65">Operator 3</td> <td class="xl65">MCCMNC3</td> </tr> <tr style="height: 15.75pt;" height="21"> <td style="height: 15.75pt;" align="right" height="21">2</td> <td class="xl66">NEW ZEALAND </td> <td class="xl67">NZ</td> <td class="xl66" align="right">64</td> <td class="xl66">GMT+12:00 </td> <td class="xl66"> </td> <td class="xl66"> </td> <td class="xl66">Vodafone</td> <td class="xl66" align="right">53001</td> <td class="xl66">Telecom</td> <td class="xl66" align="right">53005</td> <td class="xl66">2Degrees</td> <td class="xl66" align="right">53024</td> </tr> </tbody></table>

Then I have another dynamic sheet where, depending the country (first search in the thable) and depending the Operator (second search in the table) I need to provide the MCC/MNC.

Problem is that "operator" is not and unique key (Vodafone is almost present Worldwide).

I had try the next options:
=OFFSET('Countries Info'!A1;MATCH(NZ;Table1[ISO 3166-1-alpha-2 code];0);MATCH(Vodafone;OFFSET(Table1;0;0;1;COLUMN(Table1));0)-1)

=HLOOKUP(Vodafone;Table1;MATCH(Vodafone;Table1[ISO 3166-1-alpha-2 code];0)+1;FALSE)

Thank you in advance

 

[lastminuteproject]

I just installed the HTMLMaker, so maybe will be easier to understand the table like this

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
1	Country names	ISO 3166-1-alpha-2 code	International dial code	Start GMT	End GMT	Column1	Operatpr 1	MCCMNC1	Operatpr 2	MCCMNC2	Operator 3	MCCMNC3
2	NEW ZEALAND	NZ	64	GMT+12:00			Vodafone	53001	NZ-Telecom	53005	NZ-2Degrees	53024
Countries Info