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.