Email Comparison Formula Needed

rowdysmith

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

test@test.com  Bo      Sam    test@test.com   Empty  Empty    Test@test.com  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

Andrée Starå

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

rowdysmith

More than likely, it would only be one match as we have refined the data before we would put it into this process.

Rowdy

Andrée Starå

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, andree@getdone.se)

Best,

Andrée