=IFNA(Vlookup(),0,Vlookup())

I fear this is the only way

HTH
--
AP

"nir020" a écrit dans le message de
...
How can you when using vlookup return a value of 0 rather than #N/A when
the
lookup value is not present in the table array?

Thanks

Nick