Function 11)

11) Add Function IFERROR to active workbook

Using the function

= IFERROR(YourFormula,ValueIfError)

You can significantly shorten a formula from something like this:  =IF(ISERROR(VLOOKUP(A3,W:Z,3,0)),”bad”,VLOOKUP(A3,W:Z,3,0)) to this:  =IFERROR(VLOOKUP(A3,W:Z,3,0),”bad”)

Hopefully you notice that the VLOOKUP function has to be stated only once.

Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc