SOLVED

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 

=INDEX(Sheet2!B3:R88,MATCH(M4,Sheet2!A3:A88,0),MATCH(J1,Sheet2!B2:R2,0))

my question

How do I get it from the other table as well

2 Replies
best response confirmed by wanalearn (Occasional Contributor)
Solution

@wanalearn 

Not sure I understood the logic correctly, perhaps

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

@wanalearn 

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