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

Answer:

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 Student Report worksheet. Incorporate an IFERROR function so that if there is no Student ID in cell B2, a blank value ("") is returned instead of an Error.

Explanation:

In MS Excel, IFERROR function is the the function the function that is used to check the error in the formula. If the error found in the formula or some other calculation, it show the output that we want in case of error.

For example, we want to show "There is an an error" in case of error in the formula or calculation. We mention this statement as an output of the IFERROR condition. we can make it empty instead of showing the error.

In Given Question, If the there is no student ID in the Cell B2, a blank value shown on the output instead of the error to incorporate the IFERROR function.