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