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

  • Thread starter Thread starter Dmitry Kopnichev
  • Start date Start date
D

Dmitry Kopnichev

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple "lookup_value" 18
vlookup lookup_value text 3
Lookups and the next smallest value 1
LOOKUP function 4
Lookup table 3
2 or more lookup values 1
Using LOOKUP only if a value exists 5
Next largest value that is greater than lookup_value. 4

Back
Top