Hello,
I have 2 tables (same x/y) with various values (which may repeat), and I need a formula which returns 1 if:
- it finds value 1 in table 1
- it finds value 2 in table 2
- the position of the 2 values within the 2 tables is identical
I'm adding an overly simplified example sheet of what I need. It's over simplified because the 2 tables I'm actually comparing are much larger and the values inside them change according to data I add in a separate place, so I basically need this formula to track the changes that I make..
Is it possible?
Bookmarks