vlookup and date values

  • Thread starter Thread starter mark
  • Start date Start date
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
 
Hi

An Excel date is simply a number (today is 38119) that is formatted to
display as a date. It really depends on whether the info you are trying to
VLOOKUP is an Excel date (a number) or a keyed text field. Just because the
field shows May-04 does not mean that it represents May 04. It will most
likely indicate a certain day in May 04
 
Your lookup value for dates should be in the form:

DATEVALUE("May-04")

Try something like,

=VLOOKUP(DATEVALUE("May-04"),A1:B3,2,0)

Hope this helps!
 
Back
Top