VLOOKUP 00-Jan-00
 

hi all,
below is my vlookup formula, but when data base doesn't have date value
00-Jan-00 is coming out, which is really effecting my other formula which is
related cell $AW9, any solution ?

=IF($AW9="","",IF(ISNA(VLOOKUP($AW9,ShipD,5,)),"", VLOOKUP($AW9,ShipD,5,)))

VLOOKUP 00-Jan-00
 

This can be easily fixed. What would you like to see if data base doesn't
have date value ??
--
Gary''s Student - gsnu200851


"tufailjpn" wrote:

hi all,
below is my vlookup formula, but when data base doesn't have date value
00-Jan-00 is coming out, which is really effecting my other formula which is
related cell $AW9, any solution ?

=IF($AW9="","",IF(ISNA(VLOOKUP($AW9,ShipD,5,)),"", VLOOKUP($AW9,ShipD,5,)))

VLOOKUP 00-Jan-00
 

i need just as a blank cell, i means no need any value.

"Gary''s Student" wrote:

This can be easily fixed. What would you like to see if data base doesn't
have date value ??
--
Gary''s Student - gsnu200851


"tufailjpn" wrote:

hi all,
below is my vlookup formula, but when data base doesn't have date value
00-Jan-00 is coming out, which is really effecting my other formula which is
related cell $AW9, any solution ?

=IF($AW9="","",IF(ISNA(VLOOKUP($AW9,ShipD,5,)),"", VLOOKUP($AW9,ShipD,5,)))

VLOOKUP 00-Jan-00
 

Add another check:

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

Or since you're showing "" for all "errors"
=if($a2="","",if(iserror(1/len(vlookup(...))),"",vlookup(...)))
or
=if(iserror(1/len(vlookup(...))),"",vlookup(...))

xl2007 adds an =iferror() that may make it even simpler.



tufailjpn wrote:

hi all,
below is my vlookup formula, but when data base doesn't have date value
00-Jan-00 is coming out, which is really effecting my other formula which is
related cell $AW9, any solution ?

=IF($AW9="","",IF(ISNA(VLOOKUP($AW9,ShipD,5,)),"", VLOOKUP($AW9,ShipD,5,)))

--

Dave Peterson