Compare/Contrast numbers to return True/False?

[Frozin_Ice]

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!

[6StringJazzer]

This assumes that the first list is in column A and the second list is in column B of the same sheet. This formula goes in any other column on the same sheet.

Please Login or Register  to view this content.

will give TRUE for found and FALSE for not found.

[Frozin_Ice]

Due to the size of the lists, and the accompanying data, the lists are on different sheets within the same workbook currently.

However, that option could definitely be viable. I'll try playing around with it. Thanks!

[6StringJazzer]

Then on the sheet with the second list if both lists are in column A of their respective sheets:

Please Login or Register  to view this content.

You get the idea.