Many years ago when my son was small and loved a certain purple dinosaur, there was also a smaller dinosaur called BabyBop who had a comfort blankie that he carried around at all times. You can remind yourself about it here.

Excel has one of those – it’s called the IFERROR() function and you can wrap it around other functions so that instead of shrieking Value! or Div/0! or N/A! (Excel can be slightly hysterical at times…) it says something soothing like “There, there” or “No Match” . Let’s see how that looks in practice.

You can download the Before file here and there’s the finished file

Of course here is the Barney song…