
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 14, 2022 01:15 PM
Hello everyone! I have an email address column. I want to create a formula column that will search each email domain for a specific text string; if that specific string exists, the formula column will print a pre-determined ID (also as a text/string). To illustrate:
If an email address comes from abcd@paypal.com, input “PAYPAL” into the formula column. If an email address comes from zyxw@vrbo.com, input “VRBO.” I’ve tried combinations of Nested IF statements, SEARCH and FIND formulas, etc. but I’m stuck and would appreciate help. Here’s a screenshot showing the end result I’m looking for.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 14, 2022 01:29 PM
IF(
FIND("@apple.com", {Email}),
"APPL",
IF(
FIND("@beaniebabies.com", {Email}),
"BNBB",
IF(
FIND("@century21.com", {Email}),
"CENT",
IF(
FIND("@dairyqueen.com", {Email}),
"DRQN"
))))

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 14, 2022 01:29 PM
IF(
FIND("@apple.com", {Email}),
"APPL",
IF(
FIND("@beaniebabies.com", {Email}),
"BNBB",
IF(
FIND("@century21.com", {Email}),
"CENT",
IF(
FIND("@dairyqueen.com", {Email}),
"DRQN"
))))

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 14, 2022 08:28 PM
This could also be done using REGEX_EXTRACT()
to pick out the email domain, and SWITCH()
based on that to set the ID:
IF(
Email,
SWITCH(
REGEX_EXTRACT(Email, "@.*"),
"@apple.com", "APPL",
"@beaniebabies.com", "BNBB",
"@century21.com", "CENT",
"@dairyqueen.com", "DRQN"
)
)
