Iindex Match formula looking up from two tables

Occasional Contributor

I want to do this index match formula see attached

I am trying to get the matching value from the two tables in sheet 2 into sheet1 ''cell n4'' based on "cell j1" and "cell M4" this is how i did it 


my question

How do I get it from the other table as well

2 Replies
best response confirmed by wanalearn (Occasional Contributor)


Not sure I understood the logic correctly, perhaps

=IFERROR( <lookup first table>, <lookup second table> )


See I need a formula for this - I posted a reply to this question there.