$5$

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 $("\text{'}")$ instead, otherwise display the value returned by the VLOOKUP function.

Copy the formula down through F$29.$