$1.$ 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.$

$2.$ Creating a named range for all of the student data will make it easier to retrieve data about each student in the table from other worksheets. On the StudentData worksheet, create a named range, Student$\_$Data, for cells A$3$:I$34.$

$3.$ The LessonData worksheet contains the records for select students. However, their skill level is not included in the data set but is essential to calculate how much they owe for their lesson.

In cell F$3,$ enter a VLOOKUP function that will retrieve the skill level for the StudentID in cell B$3$ from the Student$\_$Data named range.

If the student does not have a skill level entered in the Student$\_$Data named range, the VLOOKUP will return a value of $0.$ Incorporate an IF function in the formula so that if the value returned is a $0,$ display a blank value $("")$ instead, otherwise display the value returned by the VLOOKUP function.

$4.$The cost of a lesson varies based on the length of the lesson and the skill level of the student. In cell G$3,$ use INDEX and MATCH functions to retrieve the lesson fee for each student from the Lesson$\_$Pricing named range. For the students with no skill level, a #N$/$A error will be returned. Incorporate an IFERROR function so that if an error is returned, the student is charged $$50$ for the lesson.

$5.$ The Report worksheet is in need of some work for it to be fully functional. When a StudentID is entered into cell B$2,$ the cells in B$3$:B$8$ should retrieve values about the student or calculate values pertaining to the student.

In cell B$3,$ enter a VLOOKUP function that will retrieve the teacher's name from the Student$\_$Data named range for the StudentID entered in cell B$2.$

Incorporate an IFERROR function to return a blank value $("")$ if there is no StudentID value in cell B$2$

$6.$In cell B$5,$ enter a VLOOKUP function that will retrieve the skill level from the Student$\_$Data named range for the StudentID entered in cell B$2.$

Incorporate an IFERROR function to return a blank value $("")$ if there is no StudentID value in cell B$2.$