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)