Answer:
IFERROR(VLOOKUP(Q2,A2:N31,2,FALSE),"Invalid Student ID")
Explanation:
The VLOOKUP function is expresses using the syntax :
=VLOOKUP(value, table array, col_index, range lookup value)
Using the IFERROR function with the VLOOKUP :
IFERROR(VLOOKUP(Q2,A2:N31,2,FALSE),"Invalid Student ID")
The VLOOKUP function here is nested with an IFERROR function is used to avoid our calculation or output resulting or showing an error and instead of throwing an error, output a statement which is defined by the user.
Here, the IFERROR function here takes the VLOOKUP function defined as its first argument, the second argument will be the output if the VLOOKUP function fails to find a match
