Note, though, that iferror() doesn't discriminate. If you're using it to
trap a specific error, for instance, the #N/A returned by an
unsuccessful VLOOKUP(), it will happily give the value_if_error value if
there are #VALUE!, #NAME!, or #REF! errors returned by VLOOKUP() as well.


In article ,
Dave Peterson wrote:

Upgrade to xl2007.

It added a new =iferror() function.