Lookup dates
 

On Mar 17, 8:37*am, Beeo wrote:
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.

I'm not quite sure that I follow you, but I think I have an idea of
what you are looking for. Try the EOMONTH function and then do a <=
comparison in an IF statement. Remember, dates are serial numbers.

Best,

Matt Herbert