7
In cell G3, add a MATCH function nested in an INDEX
function to retrieve the total fee located in the
Lesson_Pricing table on the Data Inputs worksheet for
each student listed in column B. Use one MATCH
function to determine the row based on the value in F3
(exact match). Use the second MATCH function to
determine the column based on the value in E3 (exact
match).
To prevent an error from being displayed when the skill
level is not known, nest the INDEX and MATCH
functions inside an IFERROR function and display the
default total fee of $50.
Copy the formula in cell G3 down to G17.
8