Lookup dates

[Beeo]

I have the following data in a list (excel 2003)

A..................B

1/9/2009........10
1/13/2009.......8
1/2/2009.........9
2/22/2009.......13
2/9/2009.........7
3/1/2009.........89
3/7/2009.........1
3/15/2009........9
3/7/2009..........33



I want to lookup column A for lets say all entries for
the month of January 2009 and return the values from the
B column inte a new column C

The answer is this

C
10
8
9


Can this be done? Thanks for your attention.

 

[Jacob Skaria]

Hi

Paste this formula in Range("C1"). This will display the figures for 1st
month.

=IF(MONTH(A1)=1,B1,"")


If this post helps click Yes