Using an “IF” Statement In Excel

I would like to use the “IF” statement between two spreadsheets. For instance I want A1 to say “Yes” if a2 of sheet one is the same as anything in a range of a2 through a100 of sheet two. Im using text not numbers to do this.

Thank you.