Thread: Date format when using a vlookup

I am using a vlookup to pull a column of dates into another workbook.
However, in some cases the sheet that I pull the date from has a blank in the
date column which then populates my vlookup column with a zero value.
Because the destination column is formatted as a date, I end up with a
01/00/00 value. Is there a quick and easy way to eliminate this; I'd like to
see the blank pulled forward so that if there is no date listed in the source
file the destination file is also blank.

Thanks in advance,
Rob

=if(vlookup()="","",vlookup())

might work for you.

Rob Laman wrote:
>
> I am using a vlookup to pull a column of dates into another workbook.
> However, in some cases the sheet that I pull the date from has a blank in the
> date column which then populates my vlookup column with a zero value.
> Because the destination column is formatted as a date, I end up with a
> 01/00/00 value. Is there a quick and easy way to eliminate this; I'd like to
> see the blank pulled forward so that if there is no date listed in the source
> file the destination file is also blank.
>
> Thanks in advance,
> Rob

--

Dave Peterson

Thanks Dave. My struggle was that I also have some nesting going on to
eliminate some errors for items that aren't on the source file. I was
missing an extra IF function - the scaled down version below helped to make
it clearer.

Thanks again,
Rob

"Dave Peterson" wrote:

> =if(vlookup()="","",vlookup())
>
> might work for you.
>
> Rob Laman wrote:
> >
> > I am using a vlookup to pull a column of dates into another workbook.
> > However, in some cases the sheet that I pull the date from has a blank in the
> > date column which then populates my vlookup column with a zero value.
> > Because the destination column is formatted as a date, I end up with a
> > 01/00/00 value. Is there a quick and easy way to eliminate this; I'd like to
> > see the blank pulled forward so that if there is no date listed in the source
> > file the destination file is also blank.
> >
> > Thanks in advance,
> > Rob
>
> --
>
> Dave Peterson
>