Cheers Vincnet
just what I wanted
Cheers Rexmann
"Vincnet." wrote:
=TEXT(A1,"mmmm") returns April if you have 21/04/2005 in A1
=MONTH(A1) returns 4 in the same conditions (and you can then use VLLOKUP on
this 4)
=YEAR(A1) returns 2005.
--
A+
V.
"rexmann" wrote:
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
|