Can VLOOKUP return null value?

M

Mark H.

When the VLOOKUP function refers to a blank cell, it
returns the number 0. I want it to return null. I can
use the ISBLANK function to test if the cell is blank, but
how can I have it return a null value? A zero length
string ("") won't work (because I'm importing this data
into Access, and a zero length string imported into a text
field, for some reason, generates an error). Thanks for
any tips.
 
K

Ken

Re the Access issue, have you tried to go into Table
design and set the Allow Zero Length property of the field
to "Yes"?
 
M

Mark H.

Yes I have, and it still doesn't work. It is a mystery to
me (and to my tech support desk) as to why not. By all
explanations in Access help for the AllowZeroLength
property, this should work.
 
P

Pete

Sorry to pile a question on top of an answer, but is
there a difference between a null value and having a
function such as =if(a1="","",else whatever) returning
a ""? And if so, is there an ASCII designation for a
null value, so that the replacement for "" could be =char
() where you insert the right number between the
parenthesis?
 

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

IF Function -- Return Null Value Help 2
How do I generate a "blank" value? 12
Vlookup and return sheet name also 2
how to get a function to return a null value that passes the ISBL. 7
Converting 0 values to Blanks 5
How to test for imported Access table null cell? 3
if zero, then return blank/empty 8
Identifying the # of cells containing data 3

Top