I am trying to count the an email that is in a column of one google sheet, and see if it matches another email in another column of another spreadsheet. I've tried so many formulas I just can't get it right so it's like this:
I have a spreadsheet with many columns, then in column C is the emails. This is in a completely different google sheet file. What I want to is to count the matching emails from this column to another column of another different google sheet, and that the emails that matches should turn out as named: "Applied" or just 1 or TRUE or whatever, and this result will show in another column of the same first spreadsheet.