Note that ISERROR() will also ignore errors like #VALUE!, #REF!, etc.
which may not be desirable.

In general it's better to keep error trapping as narrow as possible, in
this case:

=IF(ISNA(VLOOKUP(...)),0,VLOOKUP(...))




In article ,
Luke M wrote:

=IF(ISERROR(VLOOKUP(...)),0,VLOOKUP(...))