Comparing two columns and finding matching names

[Guest]

Please help...
I need to check one list of names against another list of names and to
determine if any of the names appear in both lists.

I.e.
Column A has 300 records
Column B has 100 records, I need to indicate if any record in Column B
matches any record in column A.

 

[JW]

Please help...
I need to check one list of names against another list of names and to
determine if any of the names appear in both lists.

I.e.
Column A has 300 records
Column B has 100 records, I need to indicate if any record in Column B
matches any record in column A.

You can use VLOOKUP, MATCH, COUNTIF etc to do this.
This will return the value is it is found:
=VLOOKUP(B1,A:A,1,FALSE)

This will return the position in the lookup_array (A:A in this
example) if the value was found:
=MATCH(B1,A1:A,0)

This will count how many times the value in B1 occurs in column A:
=COUNTIF(A:A,B1)