Vlookup If Error. And if that result is an error it will replace that error with the custom value you have specified. It lookup for a value and returns the result value if found otherwise an error.
This error is due to missing any one of the parameters in the function. Translated in plain english the formula instructs excel to return true if vlookup is true i e. However when the result in a lookup table is an empty cell no error is thrown vlookup simply returns a zero.
The iferror function was introduced in 2007.
Translated in plain english the formula instructs excel to return true if vlookup is true i e. If you look at the above image formula parameters are not in perfect order. Vlookup starts with lookup value then table range followed by a column index number and match type. What is the iferror function and why use it.
