Date format when using a vlookup

[Guest]

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]

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

might work for you.

 

[Guest]

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