Match email from one sheet to another

brian25736

I would like to set up a formula that searches an 'email' column from one sheet compared to the @row email in my main sheet, and if that email is in the other sheet colum, returns a yes or no so I can trigger off of that.

I've looked at VLOOKUP and INDEX/MATCH, but I can't seem to find a similar use case...

Sheet 1 = New Member Joins -- Email column

Sheet 2 = New Member Tutorial -- I want to see if any of the new members in Sheet 1 have already signed up for the tutorial in Sheet 2

Is there a function that helps me find an exact text match like that and return a true/false or something similar?

Dale Murphy

Brian;

You could try (a bit kludgy);

=IF(COUNTIF({EMAIL COLUMN SHEET 1}, CONTAINS($[EMAIL COLUMN SHEET 2]@row, @cell)) > 0, "YES", "NO")

(not sure I have the column names in the right order!)

Let me know.

Dale