We have already gotten used to use VLOOKUP, MATCH and other functions that generates errors inside an IF
But, we do not need that anymore
We can use the new guy, IFERROR instead, which will show the result if it did not generate error, otherwise will show something else if it resulted an error.
So, when we have this table ..
We can search for an item in first column, using VLOOKUP for example …
=VLOOKUP(J5,C:G,3,FALSE)
Which will result in an error if the item was not in list
But, if we inserted IFERROR outside of VLOOKUP, like this
=IFERROR(VLOOKUP(J5,C:G,3,FALSE),"Not found")
We can show anything if that item was not found …
A nicer way than the #N/A, don’t you think?
