Hi all,
I hope all is well and lock-down is easing safely where you are.
It has been a while since I have posted so apologies if my format is a little rusty.
I have two tables and I want to extract a field from the 2nd table based on where two criteria are met (from the first table) - I tried using vLookup which doesn't have any criteria built in and then looked at using INDEX MATCH but I'm struggling to get the formula to work...
=INDEX(TABLE2!$H$2:$H$6232,AND(MATCH(A2,TABLE2!$A$2:$A$6232,0),MATCH(D2,TABLE2!$D$2:$D$6232,0)))
Where A2 and D2 are the Criteria in TABLE1 and the target field resides in TABLE2!$H$2:$H$6232
I don't know if this can be done via INDEX MATCH but if so, can you please point me in the direction of my error?
Much appreciated
MD
I hope all is well and lock-down is easing safely where you are.
It has been a while since I have posted so apologies if my format is a little rusty.
I have two tables and I want to extract a field from the 2nd table based on where two criteria are met (from the first table) - I tried using vLookup which doesn't have any criteria built in and then looked at using INDEX MATCH but I'm struggling to get the formula to work...
=INDEX(TABLE2!$H$2:$H$6232,AND(MATCH(A2,TABLE2!$A$2:$A$6232,0),MATCH(D2,TABLE2!$D$2:$D$6232,0)))
Where A2 and D2 are the Criteria in TABLE1 and the target field resides in TABLE2!$H$2:$H$6232
I don't know if this can be done via INDEX MATCH but if so, can you please point me in the direction of my error?
Much appreciated
MD