Hi

I have a spreadsheet with a large list of dates which I want to order into
their month. I would like a Vlookup that looks at the month field and returns
the value of the Month eg

21/01/2005 (american 01/21/2005) and returns Jan from a vlookup.

How do you set it so it looks at just the month field. Ideally it will
return just the month and year (not day)

Also in a Vlookup how do you get it to round up to the highest figure rather
than down (when you use the range_lookup).

I am using Excel 2002
Any help greatly appreciated

rexmann