Switch to the Student Representatives worksheet. In cell E$2,$ enter a formula using HLOOKUP function as follows to determine a student's potential base hourly rate is based on the number of years of post$-$secondary education$)$:

a$.$ Use a structured reference to look up the value in the Post$-$Secondary Years column. Retrieve the value in the $2$ nd row of the table in the range P$13$:U$14$ using an absolute reference. Because base hourly rate is tiered based on the number of years of education, find an approximate match.