need help to get these last steps finished in the worksheet provided.

IN the lesson data worksheet 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.

In cell E12 of the report worksheet, use the VLOOKUP function nested in an IF function to retrieve the student?s uniform size. To prevent zeros from being displayed when the uniform size is not known, nest the VLOOKUP function in an IF function to leave the cell blank when the skill level equals 0. The value should be looking for an exact match. Copy the formula in E12 down to E17.

In cell F12 of the report worksheet, use the AND function nested in an IF function to determine if the student has a permission slip and a uniform. If the student has a permission slip and the uniform size is not blank, then display Yes in the field; otherwise, display No. Copy the formula in F12 down to F17.

In cell F18 of the report worksheet, use the COUNTIF function to determine how many students are currently traveling to the competition as indicated by Yes in cell range F12:F17.

In cell E8of the report worksheet, use the MATCH function nested in an INDEX function to retrieve the transportation fee located in the Trans_Fee table on the Data Inputs worksheet that meet the filter criteria in cell E4 and F18.

Students Instrument Piano Teacher Total Students StudentID 000001 000002 000003 000004 000005 000006 000007 000008 000009 000010 First Name Zia Pandora Inez Jael Minerva Summer Quyn Violet Clark Hyat Last Name White Brock Clements Boyer Burton Sweeney Ortiz Ward Ward Waters Instrument Piano Drums Viola Bass Trumpet Drums Trumbone Guitar Viola Drums Teacher Competition? Yes Jenny Chuck 2 Teacher Jenny Chuck Chuck Chuck Mark Anne Chuck Chuck Mark Jenny Uniform Size Mark 5 Competition? Yes Yes Yes No No Yes No Yes Yes Permission Slip Anne 2 Uniform Size XL M L M L XL XS XL XL XL Student Since Debbie 1 Permission Slip No Yes Yes Yes Yes Yes Yes Yes Yes Level Price Per Hour Total 0 Student Since Skill level 7/8/2012 Advanced 2/18/2015 Intermediate 11/4/2012 Intermediate 12/29/2012 7/13/2014 Expert 7/9/2014 Beginner 6/9/2013 Expert 11/7/2012 Advanced 5/30/2012 11/29/2014 Advanced 1 Price Per Hour $30.00 $25.00 $25.00 $40.00 $30.00 $40.00 $30.00 $30.00 Student Schedule Date StudentID 5/17/2015 000001 11/5/2015 000001 7/28/2015 000002 8/1/2015 000002 3/10/2015 000002 3/30/2015 000004 10/10/2015 000006 4/16/2015 000006 6/15/2015 000006 7/30/2015 000006 1/18/2015 000007 10/5/2015 000008 9/24/2015 000009 1/16/2015 000010 5/21/2015 000010 Student Zia Zia Pandora Pandora Pandora Jael Summer Summer Summer Summer Quyn Violet Clark Hyat Hyat Teacher Anne Jenny Anne Jenny Mark Anne Anne Chuck Mark Mark Jenny Chuck Chuck Chuck Mark In Lesson Length Skill Level hours 2.00 Advanced 0.50 Advanced 1.00 Intermediate 2.00 Intermediate 2.00 Intermediate 0.50 0.50 Beginner 2.00 Beginner 1.00 Beginner 1.00 Beginner 1.50 Expert 1.50 Advanced 2.00 1.50 Advanced 0.50 Advanced Total Fee $ 40.00 $ 25.00 $ 25.00 $ 35.00 $ 35.00 0 $ $ $ $ $ $ 15.00 60.00 30.00 30.00 45.00 35.00 $ $ 35.00 25.00 0 Data Inputs Annual Competition Competition Entry Fee Early Bird Regular Late $ 250 $ 500 $ 750 12/1/2015 Lesson Pricing 0.5 Beginner Intermediate Advanced Expert $ 1.0 15 $ 20 25 35 1.5 30 $ 25 30 40 2.0 45 $ 30 35 45 60 35 40 50 Transportation Fees per Person Flight Bus Charter Drive 30 $ 592 $ 86 $ 125 $ 190 20 426 84 120 190 10 382 82 115 190 0 277 80 110 190 Uniform Fees XS 0 $ 42.23 $ 15 40.59 20 39.01 25 38.17 S 43.21 $ 41.57 39.99 39.15 M 44.19 $ 42.55 40.97 40.13 L 45.17 $ 43.53 41.95 41.11 XL XXL 46.15 $ 47.13 44.51 45.49 42.93 43.91 42.09 43.07 Student Report Student ID Teacher Average Fee Skill Level Total Lessons Total Paid this Year Bonus Lessons 000008 Chuck $ $ Competiton Fees Registration Type Travel Type Uniform Size Uniform Fee $ Registration Fee $ Transportation Fee Total $ 30.00 Advanced 1 35.00 0 Regular Bus XL 500.00 Early Bird Regular Late Flight Bus Charter Drive XS S M L XL XXL 500.00 Competition Report Student ID 000001 000002 000003 000006 000008 000010 Student First Name Zia Pandora Inez Summer Violet Hyat Student Last Name White Brock Clements Sweeney Ward Waters Permission Slip? No Yes Yes Yes Yes Yes Uniform Size Total Students: Ready to go! yes Total Uniforms Ordered XL Quantity needed Price per uniform 5