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