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 = [email protected]
PP = [email protected]
JM = [email protected]
Column A Column B
VP Initials Email Address
My intention is to use the email addresses in an automation.
Any help would be appreciated.
Help Article Resources
Check out the Formula Handbook template!