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.
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula
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])
Create a new account
I already have an account
You haven't saved the current formula!
Are you sure to continue?
You haven't save the current formula!
Made with in Istanbul
START LEARNING EXCEL with SHEETZOOM