VLookup "#N/A" message

[Frank Kabel]

Hi
one approach
=IF(ISNA(VLOOKUP(...)),0,VLOOKUP(...))

-----Original Message-----
Hello all,

I would like to know if anyone knows how to get

the "#N/A" message replaced by "0" when using VLookup?