date error

  • Thread starter hitesh via OfficeKB.com
  • Start date
H

hitesh via OfficeKB.com

iam using a vlookup formula for date , but when there is no date in formulas
result is 0-jan.
if there is no date why its turn to 0-jan why this happen . pls help me
 
P

Phil

Hi Hitesh,

If there is no data in the cell, VLOOKUP returns a 0. As you have
probably formatted the cell as a date, it thinks you mean day 0, which
to Excel is before 1st January 1900.

It may help make your results clearer if you use an IF function with
four VLOOKUP, for example...


=IF(VLOOKUP(A1,Range,Col No)=0, "No Date Found",VLOOKUP(A1,Range,Col
No))

Hope this helps

Phil
 
Top