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 ...
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.