Vlookup
 

Hi :) I'm using this lookup to find a date from another tab but I would like
it to leave it blank if there is not a date instead of filling in 1/0/1900?
Does anyone know a way to fix this? Thank you!!

=VLOOKUP(B4,'Data'!A2:F7863,3,FALSE)

Vlookup
 

As the "1/0/1900" is a zero, indicatively,
you could try it like this:
=IF(VLOOKUP(...)=0,"",VLOOKUP(...))
which will return "blanks" ie: "" (zero length null strings)
where the vlook evaluates to zeros

Success? High-five it, click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"H" wrote:
Hi :) I'm using this lookup to find a date from another tab but I would like
it to leave it blank if there is not a date instead of filling in 1/0/1900?
Does anyone know a way to fix this? Thank you!!

=VLOOKUP(B4,'Data'!A2:F7863,3,FALSE)

Vlookup
 

Hi,

You could apply the following format where the VLOOKUP formula is without
needing to modify your formula:
m/d/yyyy;;

Create this format by choosing Format, Cells, Number tab, Custom and
entering it on the Type line.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"H" wrote:

Hi :) I'm using this lookup to find a date from another tab but I would like
it to leave it blank if there is not a date instead of filling in 1/0/1900?
Does anyone know a way to fix this? Thank you!!

=VLOOKUP(B4,'Data'!A2:F7863,3,FALSE)