Please enable JavaScript to view the comments powered by Disqus.


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

Managing VLOOKUP() returning error

The VLOOKUP() function may return error if an exact match 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

Syntax

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

Syntax

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

Lets chat on this