ExcelBanter - The # in my vector is absent from my array. Can I make it 0?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - The # in my vector is absent from my array. Can I make it 0? (https://www.excelbanter.com/excel-worksheet-functions/35431-my-vector-absent-my-array-can-i-make-0-a.html)

Matherley

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

Bob Umlas

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

All times are GMT +1. The time now is 05:28 PM.