VLOOKUP Returns a zero value

[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

 

[Dave Peterson]

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

or

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

 

[Nate]

Worked pefrectly. Thanks!!

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

or

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