LookUp with two criterias

[isidoro]

Search Table
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]AA[/TD]
[TD]XX[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]XY[/TD]
[TD]34[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]XZ[/TD]
[TD]42[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]XX[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]XY[/TD]
[TD]13[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]XZ[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]CC[/TD]
[TD]XX[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]CC[/TD]
[TD]XY[/TD]
[TD]8[/TD]
[/TR]
</tbody>[/TABLE]

Present Table
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Criteria 1[/TD]
[TD]Criteria 2[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]XX[/TD]
[TD]Formula[/TD]
[/TR]
</tbody>[/TABLE]
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!