Comparing Duplicates for Columns in Separate Sheets

I'm comparing data in two columns in two separate sheets, and I'm trying to create a third column that will say "Yes there's a match to this value in the separate sheet" or "no there is not a matchin...