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

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

I usually use something like this:

=if(ISNA(vlookup(A,B,C),0,vlookup(A,B,C))

Where A,B,C are the arguments of the vlookup. I usually use "" (open
quote, close quote) in place of the 0, to give me a blank response.

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?

Care to post your LOOKUP formula?

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