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

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