Build an XLOOKUP formula to display the department name.
a. Select cell D4 and start an XLOOKUP formula.
b. O Lookup the label in C4 and use absolute references to the lookup and return arrays. Note that both arrays have the same dimension.
C. Copy the formula to reach cell D33 and preserve borders. When there is no entry in column C, the standard #N/A error message displays.

Q&A Education