|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 12th, 2005, 02:54 PM
|
|||
|
|||
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? 
|
|
#2
October 12th, 2005, 03:07 PM
|
|||
|
|||
|
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.
|
|
#3
October 12th, 2005, 03:15 PM
|
|||
|
|||
|
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?
|
|
#4
October 12th, 2005, 09:47 PM
|
|||
|
|||
|
Care to post your LOOKUP formula?
Dmitry Kopnichev wrote: Hello How to make LOOKUP give zero if it can't find the lookup_value?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| to make new e-mail how i find my http | cashamil | General Discussion | 2 | April 18th, 2005 08:52 PM |
| Can't find the right lookup formula for this | bankscl | Worksheet Functions | 4 | March 28th, 2005 06:27 PM |
| V Lookup - How do you make the "Col_index_number" updated | Michael | General Discussion | 2 | February 9th, 2005 04:14 AM |
| decipher log of scanpst.exe | km | General Discussion | 0 | July 18th, 2004 09:00 AM |
| Using Lookup to find the most recent event | shane24 | Worksheet Functions | 5 | March 5th, 2004 03:15 PM |
Linear Mode
