Just note that ISERROR() will also trap 'real' errors that would
indicate a problem in the worksheet.

For instance, if a column were deleted and a #REF! error occured, using
IF(ISERROR(),,) would happily ignore that, and return "".

Using ISNA() is more specific and less prone to invalidate your model.


In article
,
" wrote:

There's also IF(ISERROR(VLOOKUP(...));"";VLOOKUP(...))