MULTIPLE IF/OR

TJB_Newbie

Is there a way to have an IF/OR statement for the following:

Column A represents the initials of an internal contact at company. Column A is part of a sheet which has 300 rows. Column A could have initials KA, PP, or JM. I need a formula which will look at Column A, read which set of initials are present, and return a defined email address. The defined email addresses would be:

KA = ka@company.com

PP = pp@company.com

JM = jm@company.com

Column A Column B

VP Initials Email Address

KA

JM

PP

PP

KA

KA

PP

JM

My intention is to use the email addresses in an automation.

Any help would be appreciated.

Tim

Jeff Reisman

@TJB_Newbie Just FYI, you'll need to use this in a Contact type column in order to use the email address to send automated alerts or update requests, or approval processes. You don't want to use OR here, since you need a different result depending on the initials provided. We can do this with nested IFs:

=IF([Column A]@row = "KA", "ka@company.com", IF([Column A]@row = "PP", "pp@company.com", IF([Column A]@row = "JM", "jm@company.com", "")))

Jeff Reisman

@TJB_Newbie Just FYI, you'll need to use this in a Contact type column in order to use the email address to send automated alerts or update requests, or approval processes. You don't want to use OR here, since you need a different result depending on the initials provided. We can do this with nested IFs:

=IF([Column A]@row = "KA", "ka@company.com", IF([Column A]@row = "PP", "pp@company.com", IF([Column A]@row = "JM", "jm@company.com", "")))

TJB_Newbie

Thanks, Jeff. I had not thought about nested IF statements. Much appreciated.