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
