VLOOKUP 00-Jan-00

  • Thread starter Thread starter tufailjpn
  • Start date Start date
T

tufailjpn

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,)))
 
This can be easily fixed. What would you like to see if data base doesn't
have date value ??
 
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.
 
Back
Top