Searching and comparing columns, and returning value into different column

Please help!

I have an exising data in which column A contains about 1000 names of different sites across the country, and column B which contains the corresponding managers names. Many of names in column B appear multiple times as same person may manage multiple sites.

Now, i have a new list of about 1500 records which don't have corresponding managers names beside. I put this in column C.

How do check if value in C1 appear in Column A, and if yes, copy the value of B1 into D1? Is this possible?

Thank you for your help.

Thank you so much it worked perfectly!