Instead of =vlookup(...), use =if(isna(vlookup(...)),0,vlookup(...))


"Dmitry Kopnichev" wrote:

Hello
How to make LOOKUP give zero if it can't find the lookup_value?