Use a lookup/index-match with multiple criteria to find a value

Dear all,

Can somebody help me please? I have the following table as an example.

Criterium 1 High Low
----------- 2-----3
Criterium 2 Yes No
----------- 5-----6
Criterium 3 Left Right
----------- 7---- 8

The data above is in one table with range A1:C6. I have used the dashes to indicate that the numbers are below the specifications (so if "High" is in cell B1, "2" is in cell B2. Also see file attached.

Now how can I find the value for: "Criterium 2", "No", in the range A1:C6 (which should be 6)?

Thanks and regards,

Juriaan.

Problem solved!


Table in the range A1:C6

Lookup criteria:

F1 = Criterium 2
G1 = No

=INDEX(INDEX(B1:C6,MATCH(F1,A1:A6,0)+1,0),MATCH(G1,INDEX(B1:C6,MATCH(F1,A1:A6,0),0),0))

Works fantastic. Thanks!