I have 2 spreadsheets with names and email addresses -

File 1: 150 records
File 2: 63000 records

I need to check if each of the emails on file 1 are there in file 2 or
not. If it is there it shoul show "yes" else show "no"

when I do a Vlookup it gives me the email ids in the cell - I am not
able to show a 'yes' or 'no' so I guess this will hav eto be a
combination of vlookup and IF statement.....any ideas?