$1$ Instruction:

Build one formula in D$6.$ When last names are entered in any

cells from C$6$ to C$18($highlighted in yellow$),$ other corresponding

information will be retrieved automatically $($i$.$e$.$ first name,

department, extension & date hired$).$

Please be noted: build only one formula $($in D$6).$ Formulas in

other cells $($i$.$e$.$ cells highlighted in blue$)$ should be generated using

fill handler.

Enter a name $$