number 7 and 8
-- P ugu . The Report worksheet is in need of some work for it to be fully functional. When a StudentiD is entered into cell B2, the cells in B3 B8 should retrieve values about the student or calculate values pertaining to the student. In cell B3, enter a VLOOKUP function that will retrieve the teacher's name from the Student_Data named range for the StudentID entered in cell B2. Incorporate an IFERROR function to return a blank value (***) if there is no Studentin value in cell B2 Hint: The the teacher's name to return is in column 4 of the Student_Data named range. Also be sure to use a False - Exact Match for the the range_lookup argument In cell B5, enter a VLOOKUP function that will retrieve the skill level from the Student Data named range for the Studenti entered in cell B2 Incorporate an IFERROR function to return a blank value (**) if there is no Studentin value in cell B2 Hint The skill level value to return is in column 8 of the Student_Data named range. Also be sure to use a False - Exact Match for the the range_lookup argument BTU. . . A . Conditional Forma Call e rt Delete format 1 Student Report 2 Student ID 1 Teacher 4 Average fee 5 Level Total Lessons 7 Total Pald this Year 8 Bonus Lessons Competiton Fees Registration Type Travel Type Uniform Size Registration Fee Transportation Fee 10 Competition Report Permission tip formie Ready to 11 Student ID 12 COOL 13 000002 14 000003 15 00005 16 000000 17 OC0010 19 000018 2000000 21 000022 Students Les Datables Report -- P ugu . The Report worksheet is in need of some work for it to be fully functional. When a StudentiD is entered into cell B2, the cells in B3 B8 should retrieve values about the student or calculate values pertaining to the student. In cell B3, enter a VLOOKUP function that will retrieve the teacher's name from the Student_Data named range for the StudentID entered in cell B2. Incorporate an IFERROR function to return a blank value (***) if there is no Studentin value in cell B2 Hint: The the teacher's name to return is in column 4 of the Student_Data named range. Also be sure to use a False - Exact Match for the the range_lookup argument In cell B5, enter a VLOOKUP function that will retrieve the skill level from the Student Data named range for the Studenti entered in cell B2 Incorporate an IFERROR function to return a blank value (**) if there is no Studentin value in cell B2 Hint The skill level value to return is in column 8 of the Student_Data named range. Also be sure to use a False - Exact Match for the the range_lookup argument BTU. . . A . Conditional Forma Call e rt Delete format 1 Student Report 2 Student ID 1 Teacher 4 Average fee 5 Level Total Lessons 7 Total Pald this Year 8 Bonus Lessons Competiton Fees Registration Type Travel Type Uniform Size Registration Fee Transportation Fee 10 Competition Report Permission tip formie Ready to 11 Student ID 12 COOL 13 000002 14 000003 15 00005 16 000000 17 OC0010 19 000018 2000000 21 000022 Students Les Datables Report
