6 On the LessonData worksheet, in cell F3, add a MATCH function nested in an INDEX function 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.

7 On the LessonData worksheet, in cell G3, add a MATCH function nested in an INDEX function to retrieve the total fee located in the Lesson Pricing table on the DataInputs worksheet for each student listed in column B depending on their lesson length and skill level. To prevent an error from being displayed when the skill level is not known, nest the INDEX and MATCH functions inside an IFERROR function, and display the default total fee of $50. Copy the formula down to G121.

Home Draw Pope Layout Formulas Help Share Comments Calculate Now Wack Function Land Time= Rumors Ties Functions= Optioni T Formula Arising MIN A C G H L M N H. Student Schedule Mudentio Student Teacher even Length Skill Level Total Fee Kimberly 1 50 IFINDEX| Skill_Level Mark Chuck 1 50 Balls 0 50 1/16/3014 030010 Hyate Chuck 1/17/3014 CO2818 Anne 2.00 10 Manny 1 30 11 1/18/3018 003807 dum Manny 1 50 12 Amani Chuck 100 13 1/21/2018 000804 Debbie 100 14 1/3 3018 003003 Meghan Jenny 1 50 15 1/36/3018 good 1.00 1/39/2014 030845 Anne 17 1/11/2014 090841 Debbie 18 Violet Debbie 100 Chuck 1 50 100 CHUCK 100 Violet Chuck StudentData Lesson Data Dulainputs Report Type here to search OHome Draw Pope Layout Formulas Help Share Comments Calculate Now Function Land Receive Arrows - ()Furhats Formada |Window Optioni T Formula Auditing A C L M IN Competition Entry Fee 1.0 1.4 Early Bird Intermediate 30 34 35 45 12 Tramportion Feet per Person 14 15 M 17 272 18 19 Unarm Fees L XL #4.19 HILST 4151 ULIT 43 09 StudentDues Lesson Data Datainputs Pleport 813AM Type here to search B 1 9