Enter a formula in cell N$8$ using the VLOOKUP function to find an exact match for the department code. Look up the department code $($cell N$7)$ using an absolute reference, return the department name $($the $2$ nd column$).$

Copy the formula in cell N$8$ to the range N$9$:N$16,$ pasting the formula only, and then edit