Find matching items in different documents

Hello everyone. I am very new here and I need an advice. I am trying to use a VLOOKUP formula in order to find matching emails in 2 different documents, for example: I have one document with a list of players, and I have another document with a similar list of players with a "STATUS" column for these players. In the second document, the emails are being added there automatically. What I need is: when the email is added automatically, to use a formula that will go through the first document where I have the list of the players and find the matching email, and once it finds, to set STATUS: DONE.
Can this be done?
Thank you in advance.

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Please start a new thread - See Forum rule #4

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

I started it for you this time