Instructions The cost of a lesson varies based on the length of the lesson and the skill level of the student. In cell G3, use INDEX and MATCH functions to retrieve the lesson fee for each student from the Lesson Pricing named range. For the students with no skill level, a #N/A error will be returned. Incorporate an IFERROR function so that if an error is returned, the student is charged $50 for the lesson. Copy the formula down through G29. 18 : fic H G Total Fee A B 2 Date Studenti Student Teacher 3 1/7/2018 000018 Kennan Meyer Jenny 4 1/8/2018 000001 Zia White Chuck 5 1/12/2018 000033 Belle Solomon Chuck 6 1/16/2018 000010 Hyatt Waters Chuck 7 1/17/2018 000018 Kennan Meyer Anne 8 1/19/2018 000028 Amena Sanchez Chuck 9 1/21/2018 000022 Rina Stanley Debbie 10 2/3/2018 000008 Violet Ward Debbie 11 2/14/2018 000008 Violet Ward Chuck 12 2/16/2018 000001 Zia White Mark 13 2/20/2018 000016 Pamela Lambert Chuck 14 3/10/2018 000002 Pandora Brock Mark 15 4/2/2018 000006 Summer Sweeney Debbie 16 4/15/2018 000022 Rina Stanley Jenny 17 4/16/2018 000006 Summer Sweeney Chuck 18 4/19/2018 000018 Kennan Meyer Chuck 19 4/20/2018 000033 Belle Solomon Chuck 20 5/6/2018 000008 Violet Ward Anne 21 5/7/2018 000018 Kennan Meyer Anne 22 5/7/2018 000025 Lee Hayden Mark 23 5/8/2018 000008 Violet Ward Debbie 24 5/9/2018 000028 Amena Sanchez Chuck 25 5/12/2018|000016 Pamela Lambert Anne 26 5/15/2018 000016 Pamela Lambert Mark 27 5/17/2018 000001 Zia White Anne 28 5/21/2018 000010 Hyatt Waters Mark 29 5/29/2018 000001 Zia White Debbie 1 StudentData LessonData Ready Lesson Length Skill Level 0.50 Expert 1.50 Advanced 0.50 Beginner 1.50 2.00 Expert 1.00 Advanced 1.00 Intermediate 1.00 Advanced 0.50 Advanced 1.00 Advanced 1.00 Beginner 2.00 Intermediate 1.50 Beginner 1.00 Intermediate 2.00 Beginner 2.00 Expert 1.50 Beginner 1.00 Advanced 2.00 Expert 0.50 Advanced 2.00 Advanced 2.00 Advanced 1.00 Beginner 1.50 Beginner 2.00 Advanced 0.50 1.00 Advanced DataTables Report + Function Library Defined Names Lesson_Pr... - : * fa ~ B 15 C D E F G H I J | 1 Data Tables 2 3 Lesson Pricing 0.5 Registration Fee Early Bird Regular $ 250 $ 500 $ $ - Late 750 5 Beginner Intermediate 7 Advanced 8 Expert 6 2.0 60 35 40 15 $ 2o| - 25 35 - 1.0 30 $ 25 30 40 | 1.5 45 $ 30 35 45 9 $ 10 Transportation Fees per Person Flight 30 $ 277 20 382 426 592 Bus 80 82 84 86 Charter $ 110 115 120 125 Drive $ 190 190 190 190 Uniform Fees XS S O $ 42.23 $ 43.21 15 40.59 41.57 39.01 39.99 38.17 39.15 Student Data LessonData Ready M $ 44.19 $ 42.55 40.97 40.13 DataTables L 45.17 | $ 43.53 | 41.95 41.11| Report XL XXL 46.15 $ 47.13 44.51 45.49 42.93 43.91 42.09 43.07 + Instructions The cost of a lesson varies based on the length of the lesson and the skill level of the student. In cell G3, use INDEX and MATCH functions to retrieve the lesson fee for each student from the Lesson Pricing named range. For the students with no skill level, a #N/A error will be returned. Incorporate an IFERROR function so that if an error is returned, the student is charged $50 for the lesson. Copy the formula down through G29. 18 : fic H G Total Fee A B 2 Date Studenti Student Teacher 3 1/7/2018 000018 Kennan Meyer Jenny 4 1/8/2018 000001 Zia White Chuck 5 1/12/2018 000033 Belle Solomon Chuck 6 1/16/2018 000010 Hyatt Waters Chuck 7 1/17/2018 000018 Kennan Meyer Anne 8 1/19/2018 000028 Amena Sanchez Chuck 9 1/21/2018 000022 Rina Stanley Debbie 10 2/3/2018 000008 Violet Ward Debbie 11 2/14/2018 000008 Violet Ward Chuck 12 2/16/2018 000001 Zia White Mark 13 2/20/2018 000016 Pamela Lambert Chuck 14 3/10/2018 000002 Pandora Brock Mark 15 4/2/2018 000006 Summer Sweeney Debbie 16 4/15/2018 000022 Rina Stanley Jenny 17 4/16/2018 000006 Summer Sweeney Chuck 18 4/19/2018 000018 Kennan Meyer Chuck 19 4/20/2018 000033 Belle Solomon Chuck 20 5/6/2018 000008 Violet Ward Anne 21 5/7/2018 000018 Kennan Meyer Anne 22 5/7/2018 000025 Lee Hayden Mark 23 5/8/2018 000008 Violet Ward Debbie 24 5/9/2018 000028 Amena Sanchez Chuck 25 5/12/2018|000016 Pamela Lambert Anne 26 5/15/2018 000016 Pamela Lambert Mark 27 5/17/2018 000001 Zia White Anne 28 5/21/2018 000010 Hyatt Waters Mark 29 5/29/2018 000001 Zia White Debbie 1 StudentData LessonData Ready Lesson Length Skill Level 0.50 Expert 1.50 Advanced 0.50 Beginner 1.50 2.00 Expert 1.00 Advanced 1.00 Intermediate 1.00 Advanced 0.50 Advanced 1.00 Advanced 1.00 Beginner 2.00 Intermediate 1.50 Beginner 1.00 Intermediate 2.00 Beginner 2.00 Expert 1.50 Beginner 1.00 Advanced 2.00 Expert 0.50 Advanced 2.00 Advanced 2.00 Advanced 1.00 Beginner 1.50 Beginner 2.00 Advanced 0.50 1.00 Advanced DataTables Report + Function Library Defined Names Lesson_Pr... - : * fa ~ B 15 C D E F G H I J | 1 Data Tables 2 3 Lesson Pricing 0.5 Registration Fee Early Bird Regular $ 250 $ 500 $ $ - Late 750 5 Beginner Intermediate 7 Advanced 8 Expert 6 2.0 60 35 40 15 $ 2o| - 25 35 - 1.0 30 $ 25 30 40 | 1.5 45 $ 30 35 45 9 $ 10 Transportation Fees per Person Flight 30 $ 277 20 382 426 592 Bus 80 82 84 86 Charter $ 110 115 120 125 Drive $ 190 190 190 190 Uniform Fees XS S O $ 42.23 $ 43.21 15 40.59 41.57 39.01 39.99 38.17 39.15 Student Data LessonData Ready M $ 44.19 $ 42.55 40.97 40.13 DataTables L 45.17 | $ 43.53 | 41.95 41.11| Report XL XXL 46.15 $ 47.13 44.51 45.49 42.93 43.91 42.09 43.07 +
