Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

6 On the LessonData worksheet, in cell F3, add a MATCH function nested in an INDEX function 8 to retrieve Skill_level of each student listed

image text in transcribed
6 On the LessonData worksheet, in cell F3, add a MATCH function nested in an INDEX function 8 to retrieve Skill_level of each student listed in column B (StudentID). 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 through cell F121

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Mathematics questions