Try this:

Make cell B2 =Date(Year(today()),Month(today()),1)

Then make sure your S20 - S31 cells are actualy dates, and not typed in
text. For example January would be 1/1/06, February would be 2/1/06,
etc.

Both cell B2 and your range of Months can be formatted to read as
"January 2006"

Now your vlookup should work (Without the B2 in quotes as previously
stated)


--
qwopzxnm
------------------------------------------------------------------------
qwopzxnm's Profile: http://www.excelforum.com/member.php...o&userid=27557
View this thread: http://www.excelforum.com/showthread...hreadid=512627