Comparing Two Columns

[jprescottjr]

Is there a way I can have excel search for a cell from column a and search to see if it is anywhere in column b? For example, column a has a listing of files that were missing from an export, column b has a listing of newly exported items. Is there a way I can search to see if items from column a are somewhere in column b?

[jprescottjr]

Oh and possibly print a list of the ones that arent there

[guyzk1]

If I understand correctly...
You can use conditional formatting - Highlight cell rules - duplicate value...

[NBVC]

Try

=ISNUMBER(MATCH(A2,B:B,0))

this returns TRUE if A2 is found in column B.

If you need position remove the ISNUMBER() part and the number returned is the position within column B that the item is found, if at all.

[jprescottjr]

Cant get this to work

[jprescottjr]

For instance one file name is 02900001 in cell 1A and i see it in Column B, but that brings back a false

[NBVC]

Assuming your first item in column A is in A2 and you want to check column B for a match.

Enter: =ISNUMBER(MATCH(A2,B:B,0)) in C2 (it should return TRUE/FALSE depending on if match is found or not)... then copy down.

What isn't working?

[jprescottjr]

You got it right, i had the wrong column! Thank you!!!!