Email Address Matching in Two Worksheets

So I have been browsing this forum for about a week as a non member and I can't figure out why any of your BRILLIANT suggestions for my issue can't work.

I have a Worksheet with two sheets in it. What I am trying to do in column A is to match Column F (email) in my Second worksheet.

See screenshot
Sheet1.png

Sheet 1
Sheet2.png

I have tried:

=IF(ISNA(MATCH(B35, INDEX('Sheet 1'!$F$2:$F1602,0,1) 0)), "No", "Yes")
=IFERROR(IF(MATCH(B35,Sheet1!$F:$F,0),"yes",),"no")
=IF(ISNA(MATCH(A35, INDEX(Email, 0, 1) 0)), "No", "Yes")

Here is where I get confused. If the there is a match then I want column A to return a Y or N. If it's "match" should it be set to "yes" for true and "no" for false?

These formulas don't work. Any help would be appreicated.

Hi, this is a long shot as I'm not an excel genius but is it not just as simple as putting in A2 =if(b1=Sheet2!f2,"yes","no")

Perhaps I'm missing something complicated you're trying to do?

It needs to search a column of data in the other sheet. It's not as simple as matching cell to cell. Make sense?