I need help with this problem.

Requirement:based on the last name,retrieve the other information (ie, first name, department , extension, date hired) Build only one formula in (D2). The rest of the formula should be generated automatically using fill handler.

You can use any of the formulas (VLOOKUP, HLOOKUP, MATCH_INDEX,COMPARE,2WAYLOOKUP OR ANY COMBINED FORMULAS TO SOLVE THIS)

Merge Center UloUrET PUnas Format ' & S . % , . . Formatting . Table* Styles . Filter Select oard Font Alignment Number Styles Cells Edting Last Neme First Name D Extension Dale Hired Enter a nan Last Name First Name Departmer Extension Date Hired Alilen Baker Nancy Operations 3432 4/16/2003 Bunnel Ken Charles Larry Administra 2822 9/16/1999 Cramden Moe Marketing Administra 1231 3/12/2001 Davis Rita Administra26044/15/2005 DunwellJames Operations 3983 Ellis EndowEd 2/9/2000 Pamela Data Proce 2144 24/2004 Data Proce 1102 11/12/2003 Requiren Based on the last name, retrieve the other information (i.e. first name, department, extension & date hired) You can use any of the formula Vlookup,hlookup,match_index compare, 2 way lookup, or any combined formulas Q1 020 Please be noted: build only one formula (in D2). The rest of the formulas should be generated automatically using fill handler