Vlookup

[goodmachine]

In column A, I have a set of codes that I would like to validate are in column B. I need a formula that will tell me what codes in column A are in column B. Second, what are the outlier codes in column B that are not in column A. Column A is the "source of truth" for the data. There may be some rogue values in column B, so I want to be able to identify those as well.

I appreciate the help.

Thanks.

 

[Jonmo1]

What codes in A that ARE in B
=ISNUMBER(MATCH(A1,B:B,0))
Filled down to end of column A
TRUE means A is in B

What codes in B that ARE NOT in A
=ISNA(MATCH(B1,A:A,0))
Filled down to end of column B.
TRUE means B is NOT in A


Hope that helps.