VLOOKUP giving values in different format

Occasional Visitor

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?

 

1 Reply

@GabMorris 

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

format painter.JPG

 

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

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

vlookup.JPG