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,)))