Ad Clicks : Ad Views :
Excel formulas and tutorials

Excel formulas and useful tools

Tag: iferror

img

Zero if error or #N/A in Vlookup

By
|
In Useful formulas
|
On September 19, 2014
Sometimes the result of an excel formula is an element of a larger and sophisticated calculation which will end displaying an error if any of the elements taken into account is not a number. This is the case of #N/A returned by the VLOOKUP function when there is no match to the searched element. The […]
It is main inner container footer text