: record which entry in one file doesn't appear in a different file

Hi dear list,

If anybody could help me, it would be great!

I have two files:
File 1 is a list (one column and around 100000 rows)
File 2 is a list with all the names from file one and a few more (one
column and more than 100000 rows)

What I want is to add a column in file 2 that says which name appeared
in file 1 and which doesn't (yes and no would work as a code)
It's very important to keep the order of the names in file 2.

Thank you!

Laura