3

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

Functionality
Industry
Department

Comments

Andree_Stara

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