$-$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, search the employee table data $($the range $B7$:$K17$ using absolute references, and 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 the copied formulas to return the value from the column indicated by the label in column M$.$