Level 2Text, Part 2Practice, 3 min
REGEXMATCH: work or personal email?
The task
Sales only calls leads with a work email. In C2, label the lead Personal if the email contains gmail, yahoo or outlook, otherwise Work. Use
REGEXMATCH inside IF.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | |
|---|---|---|---|
| 1 | Lead | Type | |
| 2 | Paige Turner | [email protected] | |
| 3 | Omar Haddad | [email protected] | |
| 4 | Sofia Alvarez | [email protected] |