Forum Discussion
Cross Reference
What formula does one use to cross-ref list A vs. B , identifying those records from A not in B?
Let's say list A is in A2:A1000, and list B in D2:D200.
Enter the following formula in B2:
=ISERROR(MATCH(A2,$D$2:$D$200,0))
This will return TRUE if A2 is not found in D2:D200, FALSE otherwise.
Fill down to B1000.