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

[Dmitry Kopnichev]

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

 

[comish4lif]

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.

 

[bpeltzer]

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

 

[Aladin Akyurek]

Care to post your LOOKUP formula?