Vlookup
 

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

=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

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