In cell E2, enter a formula using the HLOOKUP function to determine a staff member's base salary (which is based upon 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.