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.

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.

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.