Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
blank date shows up as s 1/0/00
I am doing a vlookup on a worksheet that shows a blank date in the field yet
on the vlookup it shows as 1/0/00. How can I correct this. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
blank date shows up as s 1/0/00
You seem to have the formula cell formatted as DATE so I'm assuming that
you're expecting a date result and 0 is not a possible result of the formula. Try something like this: =IF(your_vlookup_formula_here=0,"",your_vlookup_fo rmula_here) -- Biff Microsoft Excel MVP "Mary" wrote in message ... I am doing a vlookup on a worksheet that shows a blank date in the field yet on the vlookup it shows as 1/0/00. How can I correct this. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
blank date shows up as s 1/0/00
Trap for it in your formula
=IF(VLOOKUP(G1,$A$1:$F$31,2,FALSE)="","",(VLOOKUP( G1,$A$1:$F$31,2,FALSE))) Gord Dibben MS Excel MVP On Wed, 16 Jul 2008 13:43:01 -0700, Mary wrote: I am doing a vlookup on a worksheet that shows a blank date in the field yet on the vlookup it shows as 1/0/00. How can I correct this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shows blank worksheet but ok in print preview | Excel Discussion (Misc queries) | |||
Excel: I enter date and format for date, but shows as number | Excel Discussion (Misc queries) | |||
My Excel 2000 shows 97 worksheets grey-blank - help!? | Excel Discussion (Misc queries) | |||
Date shows as 01/01/00 | Excel Discussion (Misc queries) | |||
blank data field shows quote in formula, how to delete it? | Excel Discussion (Misc queries) |