Label DBA names only for type 3

Turn Acme Co. and Acme into a Legal and DBA label only for type 3.

What you'll make

In Excel: Acme Co. + Acme + 3 becomes Legal: Acme Co. ¶ DBA: Acme.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1C8=3Checks the other name is type 3, a DBA. ¶ is a line break.Yes, 3
2IF(B8="", … )Shows both names on two lines, or flags a missing DBA."Legal: Acme Co.¶…"
3IF(B8="","Legal: "&A8, … )For other types, the legal name alone, or a flag.Not used for row 8
4IF( … )Uses part 2 for type 3, otherwise part 3."Legal: Acme Co.¶…"

Read it left to right. An other name of any type but 3 is flagged, never labeled DBA.

=IF(C8=3,IF(B8="","Review missing DBA name","Legal: "&A8&CHAR(10)&"DBA: "&B8),IF(B8="","Legal: "&A8,"Review name type"))

How to use it

Yellow bar at the top? Click Enable Editing.

  1. See it work. The Example tab shows 20 made-up names with the formula already in.
  2. Use your own names. Paste legal names, other names and their type numbers into the green columns of the Template tab. Labels fill in by themselves.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Check that type 3 means Doing Business As in your list. A former legal name must never become a DBA.

Route: Get names ready for the letter

Microsoft's help: IF function