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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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"?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup problems 1
Index, Lookup and Vectors/Arrays 7
Minimum array formula. 5
Learning arrays. 13
Array-friendly functions 1
How to get Solver to target array rather than cell? 3
How can I use the * wildcard in an array formula 4
Mapping integers to strings 5

Back
Top