"In cell E2, enter a formula using the HLOOKUP function to determine a staff member's base salary (which is based on the number of years of service). a. 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 base salary is tiered based on the number of years of service, find an approximate match. b. Fill the formula into the range E3:E31, if necessary."

H 14 H 14