Use Index Function and 2 Match Functions. Build One formula in D2 and generate the rest of the formulas using fill handler.

First Name Department Extension Date Hired Last Name Enter a name - Penelie Lee Mark Harris Smith Ortiz Last Name Smith Maia Ortiz Richardo Mark Peneli France Lee Harris First Name Jim John Jacob Abraham Alex Lorenzo Kai Stan Michael Department Customer Service Customer Service Inventory Inventory Inventory Maintenance Management Maintenance Accounting Extension Date Hired 40291 4/6/1988 40295 4/14/2013 10395 5/7/2012 30593 7/6/2011 59382 1/31/1999 29483 1/5/2002 49384 1/8/2017 39539 3/14/2009 19486 11/9/1994 Requirements: Based on the last name, retrieve the other information (.e. first name, department, extension & date hired). Please be noted: build only one formula (in D2). The rest of the formulas should be generated automatically using till handler