Email Comparison Formula Needed

edited 12/09/19 in Formulas and Functions

Hello Community,

I am looking for some help with an email IF Statement and a formula to more information, when a match is detected.

I have a couple sets of 3 columns each: Email, First, Last and I need to compare Email with other sets of Emails. 

NOTE: The 2nd or 3rd or 4th set of Email, First, Last will not have First and Last names populated, only Email.


Email              | First | Last ||| Email               | First    | Last   ||| Email               | First    | Last  Bo      Sam   Empty  Empty  Empty   Empty

I need an IF statement to compare against the other Email columns to see if Email is a match to the master Email in the very first column. If any Emails match anywhere in the column, I would like SS to move over the First and Last to the matched Email.

Hopefully, that makes sense.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!