Help Index Match on Multiple Criteria

[Dinesh_Excel]

Hello Friends,

I need help in getting the value for the below table using the mapping table.

Appreciate your help here..

 

[pecoflyer]

Like this?
Don't forget to commit the formula as an array forumla with CSE

 

[John Jairo V]

Hi, to both!

Non CSE option could be (C4):
=IFERROR(INDEX($N$4:$N$8,MATCH(1,INDEX(($L$4:$L$8=$B4)*($M$4:$M$8=C$3),),)),"")

And drag it down and right. Blessings!

 

[Dinesh_Excel]

thank you all for the support ..Appreciate your help on the same