Hint: In cell E5, type =COUNTIF(Teacher,E4) and press
ENTER. To copy, press CTRL+C. To paste, press
CTRL+V. In cell K5, type
=DCOUNTA(Student_Data,A7,D1:K2)
and press
ENTER.
5
Lookup the correct price per hour for each student in the
Student_Data table based on the student's skill level: in
cell K8, use the VLOOKUP function nested in an
IFERROR function to retrieve the price per hour located
in column C in the Lesson_Pricing named range for
each student based on the student’s skill level located in
the Skill_level field. The value should be looking for an
exact match.
8