LookUp with two criterias

[isidoro]

Search Table

AA	XX	23
AA	XY	34
AA	XZ	42
BB	XX	12
BB	XY	13
BB	XZ	25
CC	XX	10
CC	XY	8

<tbody>
</tbody>

Present Table

Criteria 1	Criteria 2	Result
BB	XX	Formula

<tbody>
</tbody>

I need to build up a formula which searching criteria 1&2 on the 'search table" bring the third column (result) to the present table…….any help pls????!!!

Thanks!

 

[Andrew Poulsom]

Welcome to MrExcel.

Example:

=INDEX(C1:C8,MATCH(1,INDEX((A1:A8=A12)*(B1:B8=B12),),FALSE))

 

[isidoro]

Thanks Andrew!….was of great help!