I think a left with an index and match could work

can you mock up an example so we can test it?

Here is the mock up, but I ran into another issue.

• The third sheet "Cross match" must display the "Common Codes" listed in the first sheet. And these codes aren't always the same of course.

• The third sheet must highlight in some way the unlisted items in either sheet.

The only thing making this difficult are missing/added items in either sheet. You will notice an item on each sheet that is unlisted in the other.

Attached Files

Cross match.xlsx (14.0 KB, 11 views)