In cell E2, enter a formula using the HLOOKUP function to determine a staff members base salary (which is based on the number of years of service). 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. Fill the formula into the range E3:E31, if necessary.
Solved by G. W. in 22 mins