ExcelBanter - date error

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - date error (https://www.excelbanter.com/excel-discussion-misc-queries/115338-date-error.html)

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200610/1

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

hitesh via OfficeKB.com wrote:

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200610/1