Mornin!

I am working on a project to compare 2 lists of document numbers. The 1st list, from system 1, contains a list of active document numbers, the 2nd list, from a 2nd system, contains a list of all document numbers issued. The goal is to compare the 2 lists and determine which document numbers on list 2 that are no longer listed on list 1.

After staring at and verifying 80,000 lines of data, my brain is scrambled and I'm struggling with how to proceed this morning. Since the company fired the resident Excel guru in our area, I figured I would reach out for assistance elsewhere!

Ideally, what I would like to do is to add a column to list 2 to return a true or false response (0/1 works too) if the number from list 2 is or isn't present on list 1.

Any help or guidance is truly appreciated!