People reading the inspection log should see “On hold” without looking up H. Add the display labels alongside the original codes.

Write the three known pairs and a review result

Enter Q, D and H in A2:A4. In B2 enter the following and fill down:

=IF(A2="","",SWITCH(A2,"Q","Queued","D","Done","H","On hold","Review code"))

SWITCH compares the cell with the supplied values. The last argument catches a code that does not match.

Q maps to Queued, D to Done and H to On hold.

Illustrated status dictionary. Keep the original codes beside the labels.

Try an unfamiliar code and an empty cell

Both X and DQ should return Review code. An empty input stays empty because of the outer IF. Confirm a new code’s meaning before changing the rule, and recheck a known row afterward. Use a separate mapping table if the list grows or another team maintains it.

X and DQ show Review code, while the blank cell stays blank.

Illustrated exception check. Confirm the meaning of a new code before mapping it.

Microsoft’s SWITCH function reference