Email Comparison Formula Needed
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.
Example:
Email | First | Last ||| Email | First | Last ||| Email | First | Last
[email protected] Bo Sam [email protected] Empty Empty [email protected] 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.
Rowdy
Comments
-
Hi Rowdy,
Can there always only be one match for the email?
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
More than likely, it would only be one match as we have refined the data before we would put it into this process.
Rowdy
-
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
Check out the Formula Handbook template!