| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date error
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date error
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| Mileage Claim Formula | New Users to Excel | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Trying to pull date from field getting error. | Excel Worksheet Functions | |||
| Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Linear Mode
