Forum Discussion
Solved
Iindex Match formula looking up from two tables
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
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.
Not sure I understood the logic correctly, perhaps
=IFERROR( <lookup first table>, <lookup second table> )
