create a contact list based on three columns with emails and a 4th column with the drop down

OshaK

Hi, we're combining a legacy mailing list with the current one and would like to use the same sheet to gather new emails. because of this, we have a more complicated than usual setup.

Column 1 - Personal email

Column 2 - Current work email

Column 3 - Other email

Column 4 (drop down type) - Preferred email for Mailchimp communications (Choice 1: Personal email, Choice2: Current work email, Column 3: Other email).

Column 5: Final contact list (to be built)

I need a formula that would select a cell value from Columns 1-3 based on Column 4 choice and create a final single contact list in Column 5.

Is it possible? thank you for your help!

Paul Newcome

You would use a basic nested IF for this:

=IF([Column 4]@row = "Personal", [Column 1]@row, IF([Column 4]@row = "Work", [Column 2]@row, [Column 3]@row))