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 in cell K8 down to K17.
6
Click the Lesson Data worksheet tab. In cell F3, add a
MATCH function nested in an INDEX function to retrieve
the skill level of each student listed in column B. HINT:
In cell F3, type =INDEX(Skill_level,MATCH('Lesson
Data'!B3,StudentID,0))
To prevent zeros from displaying when the skill level is
not known, nest the INDEX and MATCH functions in an
IF function to leave the cell blank when the skill level
equals 0. Copy the formula down to F17.
8