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"?