VLOOKUP Returns a zero value
 

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

VLOOKUP Returns a zero value
 

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

or

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




Nate wrote:

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

VLOOKUP Returns a zero value
 

Worked pefrectly. Thanks!!

"Dave Peterson" wrote:

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

or

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




Nate wrote:

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