Help identifying duplicate address on 2 sheets

I have two databases with several columns of information. I am trying to identify duplicate addresses in Sheet2 that are in Sheet1. I want to create a macro or formula that will identify if the same address appears in sheet 1 or vice versa. I have attached a sample spreadsheet of the databases I am pulling from.
Basically if Sheet2!B2 is located on Sheet1!B:B I want sheet2!C2 to say yes. And I want to be able to drag that formula down through the database.