$=$ VLOOKUP $(N7,$$$B$$$7$:$$K$$$17,2,$ FALSE $)$A

$=$ VLOOKUP $(N7,$$$B$$$7$:$$K$$$17,2,$ FALSE $)$

Can someone let me know why I am not able to copy and paste the formlua in celll n$8$thru n$16?$

$13.$ 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 B$7$:K$17)$ using absolute references, and return the department name $($the $2$nd column$).$