Switch to the All Employees worksheet. In cell E$3,$ enter a formula using the HLOOKUP function as follows to determine an employee's potential pay rate, which is based on their years of experience:

a$.$ Use a structured reference to look up the value in the Years of Experience column. Retrieve the value in row $2$ of the table in the range $P14$:$U15,$usinga$\frac{n}{a}bs$ olute reference. Because hourly pay rate is tiered based on the number of years of experience, find an approximate match.