Build one formula in D$6.$ When last names are entered in any cells from C$6$ to C$15($highlighted in yellow$),$ other corresponding information will be retrieved automatically $($i$.$e$.$ first name, department, extension & date hired$).$