vlookup and date values

M

mark

I am tryin to use a Vlookup that uses a date eg May-04 as
the lookup_value, however this does not seem to work, os
there any way i can use dates with VLookup?
many thanks
Mark
 
J

Jason Morin

VLOOKUP can handle dates. One reason it may not work is
that your lookup value is text and the lookup table
contains actual dates, or vice versa.

HTH
Jason
Atlanta, GA
 
Top