Hi there,
I have two tables from different sources and they should so the same information.
I have an unique ID column in each table and I am currently trying to use a index match function to check different coulms for matches using the ID as a reference.
What I have so far is:
=INDEX(D2:D68,MATCH(AT2,E2:E68,0))
The D column is the unique ID in table 1,AT is the column im looking to compare in table 2, column E is what I'm checking that value against in table 1.
Basically I want it to match column E (table 1 to the data in column AT (table 2) and give me back the unique ID so I can highlight duplicates and check discrepancies.
Thanks for any help
I have two tables from different sources and they should so the same information.
I have an unique ID column in each table and I am currently trying to use a index match function to check different coulms for matches using the ID as a reference.
What I have so far is:
=INDEX(D2:D68,MATCH(AT2,E2:E68,0))
The D column is the unique ID in table 1,AT is the column im looking to compare in table 2, column E is what I'm checking that value against in table 1.
Basically I want it to match column E (table 1 to the data in column AT (table 2) and give me back the unique ID so I can highlight duplicates and check discrepancies.
Thanks for any help
