Keep requester and performer apart

Who asks for a referral isn't always who does it. Show both.

What you'll make

In Excel: Ava Reed + ENT becomes Requester: Ava Reed; requested performer: ENT.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1IF(A8="","Requester absent", … )Writes the requester, or absent if it's empty."Requester: Ava Reed"
2&"; "&Adds a semicolon and a space."Requester: Ava Reed; "
3IF(B8="","requested performer absent", … )Adds the performer, or absent if it's empty."… performer: ENT"

Read it left to right. Each & joins the next piece on. Neither cell fills in for the other.

=IF(A8="","Requester absent","Requester: "&A8)&"; "&IF(B8="","requested performer absent","requested performer: "&B8)

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 list. Paste each referral's requester and requested performer into the green columns of the Template tab.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Fill in an absent performer from the referral itself. Don't assume the requester will do it.

Microsoft's help: IF function