How should the hlookup formula be entered into 2016 excel?

In cell E2, enter a formula using the HLOOKUP function and structured references to determine a staff member's pay rate (which is based on the number of years of service). 3. Use a structured reference to look up the value in the Service Years column. Retrieve the value in the 2nd row of the table in the range Q15:U16. Since staff members do not receive a raise after every year of service, find an approximate match. a. Fill the formula into the range E3:E31 if necessary. b. In cell G2, enter a formula without a function using structured references to determine the number of years since Alison Simoneau completed the HR 4. New Perspectives Excel 2016 | Module 8: SAM Project 1b training. The formula should subtract the value shown in the HR Training Year column from 2017 and should automatically fill to the range G3:G31. 5. The HR Department updated their training two years ago. The conditional formatting rule Luke created in the range G2:G31 does not clearly identify those staff members wh c mnleted the HR tra in ina