VLOOKUP Returns a zero value


N

Nate

I'm using a if/vlookup formula in XL2003 to return dates from another
worksheet. Not all accounts are listed on the worksheet, which is why I have
the ISNA formula. The problem is that some accounts are listed, but don't
have a date entered. I want the formula to return a blank, but it returns a
zero. Any suggestions on how I could manipulate this to fit what I'm trying
to do? =IF(ISNA(VLOOKUP(C3, 'TM-PDR-DO'!$A$3:$Z$231, 2, FALSE)), "",
VLOOKUP(C3, 'TM-PDR-DO'!$A$3:$Z$231, 2, FALSE))
Thanks,
Nate
 
Ad

Advertisements

D

Dave Peterson

=if(isna(vlookup(...)),"",if(vlookup(...)="","",vlookup(...))))

or

=if(iserror(1/len(vlookup(...)),"",vlookup(...))
 
Ad

Advertisements

N

Nate

Worked pefrectly. Thanks!!

Dave Peterson said:
=if(isna(vlookup(...)),"",if(vlookup(...)="","",vlookup(...))))

or

=if(iserror(1/len(vlookup(...)),"",vlookup(...))
 

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

Top