8. Lael wants a quick way to look up students by their Student ID. In cell Q3, nest the existing VLOOKUP function in an IFERROR function. If the VLOOKUP function returns an error result, the text Invalid Student ID should display. X Create a formula using a function. In the Student Representatives worksheet, the formula in cell Q3 has not been entered correctly. Q3 A 1 Student ID Name 2 G62918 3 P49234 4 W99035 5 V42056 6 T59828 7 F72412 8 W20999 9 Q18870 10 W75774 11 N25220 12 094361 13 G87578 14 B68170 15 M89375 16 S63900 17 Y96036 18 C82505 19 Y75358 20 J60811 21 Q56783 22 Q75281 23 V73596 24 L86947 25 W90960 26 P40886 27 U88627 28 Y88831 29 P83373 30 B53454 31 A60088 32 B Kay Colbert Michael Crozier Brandon Miles Michael Alvarez Ida Smith Betty Garza Leroy Pirkle Warren Stewart Stacy Wiggins Billy Herald Margaret Cruz Chester Keese Claudette Littell Florence Miller Kimberly Gerace Roman Goble Jocelyn Allen Ron Morse Roberta Ervin James Rusnak Suzanne Lawrence ShannonGarner Emory Little Laura Li Floretta Cauthen Beverly Berry Stephanie Papa Wallace Rivera Larry Russell Aaron Sifford fx =VLOOKUP(Q2,Student Representatives[[Student ID]:[Name]],2) H Grad Student Yes Yes No No No Age 24 25 21 22 19 24 28 18 24 21 23 18 19 21 26 22 22 20 21 19 24 18 25 24 18 23 19 29 19 25 D Post-Secondary Years 6 7 3 4 2 6 10 0 6 3 5 0 1 3 8 4 4 2 3 1 2 0 5 6 0 5 1 9 1 7 E Base Rate F Class 16.50 16.50 15.75 15.75 15.75 16.50 17.50 G Finance Certified 2022 Yes 2023 Yes 2022 Yes 2023 Yes 2024 No 2025 Yes 2022 Yes 15.00 16.50 15.75 16.50 15.00 15.25 15.75 17.50 15.75 15.75 15.75 15.75 15.25 15.75 15.00 16.50 16.50 15.00 16.50 15.25 17.50 15.25 16.50 2026 No 2025 Yes 2022 No 2023 Yes 2024 No 2026 Yes 2023 Yes 2023 Yes 2025 Yes 2022 Yes 2022 Yes 2026 No 2022 Yes 2025 Yes 2024 No 2023 Yes 2022 Yes 2025 No 2023 Yes 2023 Yes 2023 Yes 2022 No 2023 Yes Yes Yes No Yes No No No No No Yes No No No No No No No Yes Yes No No No Yes No Yes I Elected No Yes Yes No Yes No No No Yes No No No No No No No Yes No No Yes Yes No Yes Yes No No Yes No No Yes Qualified Driver YES YES NO NO NO YES YES NO YES NO NO NO NO NO YES NO NO NO NO NO YES NO YES YES NO NO NO YES NO YES K Leadership Training yes yes yes yes yes yes yes no yes yes yes no yes yes yes yes yes yes yes yes yes no yes yes no yes yes yes no yes Mentor Yes Yes Yes Yes No Yes Yes No Yes Yes Yes No No Yes Yes Yes Yes No Yes No No No Yes Yes No Yes No Yes No Yes M Officer Qualified Yes Elected Elected Yes Elected Yes Yes No Elected No Yes No Yes Yes Yes Yes Elected Yes No Elected Elected No Elected Elected No Yes Elected Yes No Elected N Tier 2 2 1 2 1 2 2 1 2 1 2 1 1 1 2 2 2 1 1 1 1 1 2 2 1 NEZIN 2 1 2 1 2 O Student ID Student Name P Elected Students All Students Postsecondary Years Base Rate Q G62918 Kay Colbert Total Students 11 30 0 15 R Average Post-Secondary Years 4 3.8 1 15.25 S 2 15.75 T 5 16.5 U 8 17.5 V 8. Lael wants a quick way to look up students by their Student ID. In cell Q3, nest the existing VLOOKUP function in an IFERROR function. If the VLOOKUP function returns an error result, the text Invalid Student ID should display. X Create a formula using a function. In the Student Representatives worksheet, the formula in cell Q3 has not been entered correctly. Q3 A 1 Student ID Name 2 G62918 3 P49234 4 W99035 5 V42056 6 T59828 7 F72412 8 W20999 9 Q18870 10 W75774 11 N25220 12 094361 13 G87578 14 B68170 15 M89375 16 S63900 17 Y96036 18 C82505 19 Y75358 20 J60811 21 Q56783 22 Q75281 23 V73596 24 L86947 25 W90960 26 P40886 27 U88627 28 Y88831 29 P83373 30 B53454 31 A60088 32 B Kay Colbert Michael Crozier Brandon Miles Michael Alvarez Ida Smith Betty Garza Leroy Pirkle Warren Stewart Stacy Wiggins Billy Herald Margaret Cruz Chester Keese Claudette Littell Florence Miller Kimberly Gerace Roman Goble Jocelyn Allen Ron Morse Roberta Ervin James Rusnak Suzanne Lawrence ShannonGarner Emory Little Laura Li Floretta Cauthen Beverly Berry Stephanie Papa Wallace Rivera Larry Russell Aaron Sifford fx =VLOOKUP(Q2,Student Representatives[[Student ID]:[Name]],2) H Grad Student Yes Yes No No No Age 24 25 21 22 19 24 28 18 24 21 23 18 19 21 26 22 22 20 21 19 24 18 25 24 18 23 19 29 19 25 D Post-Secondary Years 6 7 3 4 2 6 10 0 6 3 5 0 1 3 8 4 4 2 3 1 2 0 5 6 0 5 1 9 1 7 E Base Rate F Class 16.50 16.50 15.75 15.75 15.75 16.50 17.50 G Finance Certified 2022 Yes 2023 Yes 2022 Yes 2023 Yes 2024 No 2025 Yes 2022 Yes 15.00 16.50 15.75 16.50 15.00 15.25 15.75 17.50 15.75 15.75 15.75 15.75 15.25 15.75 15.00 16.50 16.50 15.00 16.50 15.25 17.50 15.25 16.50 2026 No 2025 Yes 2022 No 2023 Yes 2024 No 2026 Yes 2023 Yes 2023 Yes 2025 Yes 2022 Yes 2022 Yes 2026 No 2022 Yes 2025 Yes 2024 No 2023 Yes 2022 Yes 2025 No 2023 Yes 2023 Yes 2023 Yes 2022 No 2023 Yes Yes Yes No Yes No No No No No Yes No No No No No No No Yes Yes No No No Yes No Yes I Elected No Yes Yes No Yes No No No Yes No No No No No No No Yes No No Yes Yes No Yes Yes No No Yes No No Yes Qualified Driver YES YES NO NO NO YES YES NO YES NO NO NO NO NO YES NO NO NO NO NO YES NO YES YES NO NO NO YES NO YES K Leadership Training yes yes yes yes yes yes yes no yes yes yes no yes yes yes yes yes yes yes yes yes no yes yes no yes yes yes no yes Mentor Yes Yes Yes Yes No Yes Yes No Yes Yes Yes No No Yes Yes Yes Yes No Yes No No No Yes Yes No Yes No Yes No Yes M Officer Qualified Yes Elected Elected Yes Elected Yes Yes No Elected No Yes No Yes Yes Yes Yes Elected Yes No Elected Elected No Elected Elected No Yes Elected Yes No Elected N Tier 2 2 1 2 1 2 2 1 2 1 2 1 1 1 2 2 2 1 1 1 1 1 2 2 1 NEZIN 2 1 2 1 2 O Student ID Student Name P Elected Students All Students Postsecondary Years Base Rate Q G62918 Kay Colbert Total Students 11 30 0 15 R Average Post-Secondary Years 4 3.8 1 15.25 S 2 15.75 T 5 16.5 U 8 17.5 V