Forum Discussion
VLOOKUP giving values in different format
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?
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.