I was wondering if there was a quicker way of doing this code in a cell:
=IF(AND(G2=J2,H2=K2),1, IF(AND(G2=J3,H2=K3),1, IF(AND(G2=J4,H2=K4),1, 0)))
The code's meant to compare if my two inputs in G2 and H2 match anything within a list (J2:J4 and K2:K4 in this case). Is there a way of optimizing it using code within the cell sheets or will I have to get into VBA and create a walking loop for this to work?
Bookmarks