IFERROR(...)
How to handle VLOOKUP() returning error
Used Functions
Category: Logical
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula
Syntax
IFERROR(value, value_if_error)
Practice IFERROR Formula at Sheetzoom
IFERROR formula at Microsoft helpCategory: Lookup and reference
Looks in the first column of an array and moves across the row to return the value of a cell
Syntax
VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
0
An error can be returned by VLOOKUP() function if an exact match of the criteria is not found. To handle such a case we use IFERROR() formula that replaces error message with a custom message you want to display.