Thread: Lookup dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Beeo[_2_] Beeo[_2_] is offline
external usenet poster
 
Posts: 1
Default Lookup dates

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.