Match 2 criteria with INDEX to return value from another cell

I am trying to pull a value if 2 values in separate columns match...see attachment for example with my formula's.

Originally Posted by protonLeah

Maybe:

=INDEX($E$5:$E$14,MATCH($M5&N$4,$C$5:$C$14&$D$5:$D$14,0))

This is correct but its used as a array so press ctrl+shift+enter once you imput the code

That's it. I had tried that before but could not get the { } to show up. This time it did. Thank you!

I've tried that one also and get #VALUE!

here is some sample code 2 criteria look up