New function IFERROR, finally

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?

 

Comments

comments

Related posts