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

In Excel: 201-555-0123 Verified + backup becomes 201-555-0123.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1AND(A8<>"",B8="Verified")Checks the primary phone is there and Verified.Yes
2A8The primary phone, unchanged."201-555-0123"
3IF(AND(C8<>"",D8="Verified"), … )Else the backup if Verified, or a Review note.Not used for row 8
4IF( … )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.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. 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.
  3. 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.