Suppress phones marked Do not use
Leave the phone blank when it's marked Do not use. Approved phones pass through.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | B8="Do not use" | Checks if the status says Do not use. | Yes |
| 2 | B8="Approved" | Else checks if the status says Approved. | Not used for row 8 |
| 3 | IF(A8="", … ,A8) | The phone, or a Review note if it's empty. | Not used for row 8 |
| 4 | "Review phone status" | Shown for any other status. | Not used for row 8 |
| 5 | IF( … ) | Blank if part 1 says yes, else parts 2 to 4. | "" |
Read it left to right. Do not use always wins, so that phone is never shown. Capitals don't matter. The numbers here are made-up.
=IF(B8="Do not use","",IF(B8="Approved",IF(A8="","Review missing phone",A8),"Review phone status"))How to use it
Yellow bar at the top? Click Enable Editing.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- Use your own numbers. Paste each phone and its status into the green columns of the Template tab. The phone to use fills in by itself.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
This only reads the status column. It doesn't check consent or the rules for contacting people.
Microsoft's help: IF function
OTHER ROUTES YOU MIGHT LIKE

Use a verified primary or backup phone
201-555-0123 Verified + backup → 201-555-0123
Get the template →
Pick the Mobile or Office phone
Mobile, 201-555-0123, 617-555-0142 → 201-555-0123
Get the template →
Read national digits after a calling code
+39065550123, code 39 → 065550123
Get the template →
Hide "Phone:" when there's no phone number
(blank) → no "Phone:" line
Take this route →