Use a verified primary or backup phone
Use the primary phone when it's Verified, else a Verified backup. Others are flagged.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | AND(A8<>"",B8="Verified") | Checks the primary phone is there and Verified. | Yes |
| 2 | A8 | The primary phone, unchanged. | "201-555-0123" |
| 3 | IF(AND(C8<>"",D8="Verified"), … ) | Else the backup if Verified, or a Review note. | Not used for row 8 |
| 4 | IF( … ) | Uses part 2 if part 1 says yes, else part 3. | "201-555-0123" |
Read it left to right. An unverified primary never beats a verified backup. Capitals don't matter. The numbers here are made-up.
=IF(AND(A8<>"",B8="Verified"),A8,IF(AND(C8<>"",D8="Verified"),C8,"Review verified phone"))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 primary and backup phone with 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 columns. Make sure someone really checked each number first.
Microsoft's help: Using IF with AND, OR and NOT
OTHER ROUTES YOU MIGHT LIKE

Pick the Mobile or Office phone
Mobile, 201-555-0123, 617-555-0142 → 201-555-0123
Get the template →
Suppress phones marked Do not use
201-555-0123 + Do not use → blank
Get the template →
Create a phone-and-fax block
2015550123 + 2015550142 → Phone: 2015550123¶Fax: 2015550142
Get the template →
Hide "Phone:" when there's no phone number
(blank) → no "Phone:" line
Take this route →