VLOOKUP giving values in different format

Copper Contributor

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


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

format painter.JPG



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