filter 400 names from list 1 from list 2 with 4000 names

[Guest]

I have two lists, one with 400 names and one with 4000 names. I want to find
out how many of the 400names are on the list of 4000. Please help.

 

[Biff]

See replies to your multiple posts.

Biff

 

[Vlad005]

Enter this formula in column B.

=SUM(IF(A1=$C$1:$C$4000,1)) enter this formula and than press
Ctrl+Shift+Enter together.

In column A should be 400 name list.
In column C - 4000 name list.
Copy down this formula for all 400 names in column A.