Iferror Function In Excel Vlookup. Depending on your business needs you may want to disguise the error with your own text zero or a blank cell. There is also a function named ifna in excel which performs a very similar job to iferror.
So when the common value not matched with the second data then formula give us n a error as output. There is also a function named ifna in excel which performs a very similar job to iferror. As we all know that excel iferror function is used to return customised output when an error occurs.
The ifna function was released in 2013 and traps the n a.
Vlookup function lookups at the values from the selected range or table and returns the exact or approximate match. So when the common value not matched with the second data then formula give us n a error as output. In this article we will learn how to use vlookup iferror function to ignore the n a error while calculating the formula. It specifically targets the error generated in the vlookup example.
