lookup/vlookup for dates, please help!
 

I want to use lookup or vlookup to extract dates from a different
spreadsheet. I can get it it to extract dates in the columns but when there
is no date in a cell for the given column it returns a date of 1/0/1900. I
can't have that date showing, I need to have a blank cell like it is on the
sheet I'm taking the dates from. is there any way to get it to return
nothing, without having to put spaces in the cells? Any help on how to do
this would be so great! Thank you!!

lookup/vlookup for dates, please help!
 

You put put the vlookup inside an IF, checking for a 0 result (it's a 0
value, formatted as a date, that shows 1/0/1900). So instead of =vlookup(),
your equation would be =if(vlookup(...)=0,"",vlookup(...)).
--Bruce

"soozanne" wrote:

I want to use lookup or vlookup to extract dates from a different
spreadsheet. I can get it it to extract dates in the columns but when there
is no date in a cell for the given column it returns a date of 1/0/1900. I
can't have that date showing, I need to have a blank cell like it is on the
sheet I'm taking the dates from. is there any way to get it to return
nothing, without having to put spaces in the cells? Any help on how to do
this would be so great! Thank you!!