Iferror Excel Vlookup. So when vlookup returns an error ifna converts it into true. When excel vlookup fails to find a lookup value it throws an n a error like this.
In older version of excel iferror is not there. If isna vlookup a1 table 2 false not found vlookup a1 table 2 false in this formula you have evaluated vlookup with isna which only evaluates n a and return true. So when the common value not matched with the second data then formula give us n a error as output.
And the formula will be.
And the formula will be. In this article we will learn how to use vlookup iferror function to ignore the n a error while calculating the formula. So when vlookup returns an error ifna converts it into true. As we know iferror is an error handling function and vlookup is a referencing function these functions are combined and used so that when vlookup encounters an error while finding or matching the data the formula must know what to do when it encountered an error vlookup function is nested in the iferror function.
