I’m trying to compare inventory part numbers in column A (in the system) and column B (physically counted).
If the numbers appear in A and B, I want them to appear in column C, meaning all is good.

If they appear in A, but not in B, I want them to appear in D, as “in the system, but not physically counted”

If they appear in B, but not in A, I want them to appear in E, as “physically seen, but not in the system”

Any help will be greatly appreciated.


Lester Moore