Home |
Search |
Today's Posts |
#1
|
|||
|
|||
The # in my vector is absent from my array. Can I make it 0?
I am working on a spreadheet (many tabs) and am using one tab for my LOOKUP.
However, there are occasions where the value in the array is not present in the vector. When this happens, it puts another number in the cell, rather than just putting a "0" in it. How can I make it default to "0"? |
#2
|
|||
|
|||
LOOKUP doesn't have a FALSE parameter for exact matches as VLOOKUP, HLOOKUP
do. If you can't use these, have a look at INDEX(MATCH(... Bob Umlas Excel MVP "Matherley" wrote in message ... I am working on a spreadheet (many tabs) and am using one tab for my LOOKUP. However, there are occasions where the value in the array is not present in the vector. When this happens, it puts another number in the cell, rather than just putting a "0" in it. How can I make it default to "0"? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pass an array to Rank | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Where is the bug in my array? | Excel Discussion (Misc queries) | |||
Formula to list unique values | Excel Worksheet Functions | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |