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)