So I have two sheets with same type of data but for different months from different systems. I want to see if both systems have same data for each ID and if for each SK ID the org ID and Entity ID matches.
First sheet has 50,000 columns and second one is 150,000.
Columns :- A :- SK ID B :-Org ID C :- Entity ID
So SK ID in Sheet 1 should match SK ID in Sheet 2
AND For each SK ID that matches, does the Org ID and Entity ID associated with it also matches for both sheets? If not, then what doesn't match? Do all three differ or just Org ID is different rest matches, etc. There are various duplicates for IDs so that I'll take care of next.
One sheet has less rows than other one, so I'll be using the sheet with less rows to do the matching.
I tried using index, match, lookups, if statements, nothing seems to be working for some reason.
If it's possible for the output to be "Match" or "No Match" or maybe something where I can have output from the other table and then I can put a if statement to see if A1 matches B1 to C1, etc.
Again, I want to see if A1,B1,and C1 would match with ANY cell from A1-A150,000, B1-B150000, and C1-C150000, in other sheet. And if all match then maybe say "Match" and if one or other doesn't match then list or tell what doesn't?