Email Comparison Formula Needed
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.
Email | First | Last ||| Email | First | Last ||| Email | First | Last
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.
Help Article Resources
Check out the Formula Handbook template!