Question
How can I use IFERROR() with VLOOKUP to display a default value when the lookup fails?
Asked by: USER1915
86 Viewed
86 Answers
Answer (86)
To use IFERROR() with VLOOKUP, you'd use this formula: `=IFERROR(VLOOKUP(lookup_value, lookup_table, column_index, [range_lookup]), default_value)`. Replace `lookup_value` with the value you're searching for, `lookup_table` with the range containing your lookup data, `column_index` with the column number containing the value you want to return, and `default_value` with the value you want displayed if the lookup fails.