Match email from one sheet to another

Options

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?

Answers

  • Dale Murphy
    Dale Murphy ✭✭✭✭✭✭
    Options

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!