VLOOKUP giving values in different format

[GabMorris]

I am using VLOOKUP to cross reference two email list to return a last log-in date. It is returning a value in different format. Is there something I can do to fix this?

[#2]

@GabMorris 

With the format painter you can apply the format of the dates and times of column B to the result column.

=VLOOKUP(D1,$A$1:$B$9,2,FALSE)

In the VLOOKUP you should fix the lookup matrix with dollar signs.