Question

The second half to the Student Report will retrieve the specific fees for which the student whose ID is in cell B2 is responsible. In cell E5, enter a VLOOKUP function that will retrieve the student's Uniform Size from the range A12:E36 on the StudentReport worksheet. Incorporate an IFERROR function so that if there is no Student ID in cell B2, a blank value ("") is returned instead of a___________.

Answer 1

To retrieve a student's Uniform Size using the student ID in cell B2 with a VLOOKUP function and handle errors with IFERROR, the following Excel formula should be entered in cell E5: '=IFERROR(VLOOKUP($B$2, StudentReport!$A$12:$E$36, 5, FALSE), "")'. It returns the Uniform Size or a blank value if an error occurs or if there is no ID.

Step-by-step explanation:

To retrieve the Uniform Size for a student using a VLOOKUP function, while also handling errors with the IFERROR function in Excel, you can use the following formula in cell E5:

=IFERROR(VLOOKUP($B$2, StudentReport!$A$12:$E$36, 5, FALSE), "")

This formula will look for the student ID located in cell B2 within the range A12:E36 on the StudentReport worksheet. If the student ID is found, it will return the value in the fifth column of the range (which corresponds to the Uniform Size). If the student ID is not present in cell B2 or an error occurs during the lookup, a blank value ("") will be returned, preventing any error messages from being displayed.