Please enable JavaScript to view the comments powered by Disqus.

IFERROR(...VLOOKUP(...B12,A4:B10,2,0),"Match Not Found")

How to handle VLOOKUP() returning error

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.

Used Functions

Category: Logical

Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula


IFERROR(value, value_if_error)

Category: Lookup and reference

Looks in the first column of an array and moves across the row to return the value of a cell


VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])

Lets chat on this