The StudentData worksheet contains data about each of Fiddlers student clients. The lesson price per hour varies based on the student's skill level.

In cell I$3,$ enter an INDEX function with a MATCH function to retrieve the lesson price for $1$ hour, located in column $2$ in the Lesson$\_$Pricing named range, for each student on the basis of the student$$s skill level, located in the Skill level field. To prevent an error from being displayed when the skill level is not known, use the IFERROR function to leave the cell blank.

Copy the formula through cell I$34.$The StudentData worksheet contains data about each of Fiddlers student clients. The lesson price per hour varies based on the student's skill level.