Solve : Excel vlookup with a date?

1.	Solve : Excel vlookup with a date?
Answer» I am trying to use vlookup in excel 2002 and the lookup value is a date (1-1-2004). There are 2 columns in the table array, first column has 1-12 and second column has Jan-Dec. The result of the lookup value is December, which is wrong. I TRIED changing the format of the date (2004-1-1 ETC.) but the end result is the same. The vlookup function I used was =vlookup(b2,a2:b13,2). Does anyone know why I am having a PROBLEM with a date value? Other lookup functions that I tried WITHOUT using a date worked fine. ThanksTry changing your formula to: =vlookup(month(b2),a2:b13,2)Thanks, Oldun. It works with the the function you wrote.

Discussion