Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
Care to post your LOOKUP formula?
Dmitry Kopnichev wrote: Hello How to make LOOKUP give zero if it can't find the lookup_value? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find last occurance of text in range | Excel Worksheet Functions | |||
Complicated lookup function | Excel Worksheet Functions | |||
compicated lookup funtion | Excel Discussion (Misc queries) | |||
The match and lookup functions can find literal data but not the same data referenced from a cell | Excel Discussion (Misc queries) | |||
Using the Find tool in EXCEL | Excel Worksheet Functions |