Question 3) In cell G2, write a formula using the VLookup function to return the commission rate of employees in 2015 based on their years of experience. You need to use the commission rate look up table. Use structured references to refer to columns in the table. Use absolute reference to the commission rate table.

\begin{tabular}{|l|r|r|r|} \cline { 2 - 4 } \multicolumn{1}{c|}{} & \multicolumn{3}{c|}{ Average Salary Lookup } \\ \cline { 2 - 4 } & Analyst & Associate & \multicolumn{1}{c|}{ VP } \\ \hline Oklahoma & $65,000 & $75,000 & $120,000 \\ \hline Texas & $70,000 & $90,000 & $150,000 \\ \hline Colorado & $75,000 & $85,000 & $175,000 \\ \hline \end{tabular} \begin{tabular}{|l|r|r|r|} \cline { 2 - 4 } \multicolumn{1}{c|}{} & \multicolumn{3}{c|}{ Average Salary Lookup } \\ \cline { 2 - 4 } & Analyst & Associate & \multicolumn{1}{c|}{ VP } \\ \hline Oklahoma & $65,000 & $75,000 & $120,000 \\ \hline Texas & $70,000 & $90,000 & $150,000 \\ \hline Colorado & $75,000 & $85,000 & $175,000 \\ \hline \end{tabular}