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

There is a optional fourth parameter that can be used with VLOOKUP -
if omitted (as in your case) or set to TRUE or 1 then the function
needs to have the data table sorted. However, if it is set to FALSE or
0 then the data does not need to be sorted and the function will
return an exact match. So, try this:

=VLOOKUP(O14,Sheet2!$A$2:$L$12804,9,0)

Hope this helps.

Pete

On Nov 23, 10:02 am, 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

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