Mary,
Try this:
=VLOOKUP(O14,Sheet2!$A$2:$L$12804,9,FALSE)

"Mary" wrote:

Hi there,

I am trying to do a Vlookup on some activity dates. My formula is
=VLOOKUP(O14,Sheet2!$A$2:$L$12804,9) where the value is an activity ID and
the index column is the finish date which is in date format. However the date
that I get from the VLOOKUP is not the same date as in the table. Some dates
are correct while some are not. I have checked many times but still don't
know what is the problem. Appreciate if anyone can help me.

Regards,
Mary