Vlookup

  • Thread starter Thread starter H
  • Start date Start date
H

H

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)
 
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
 
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.
 
Back
Top