date error

[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

 

[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