C

#### ck13

A B

1 31-Dec-2009 50

2 4-Jan-2010 30

3 5-Jan-2010 20

In C, I have the date for the first day of every month e.g. 1-Jan-2010. In

the adjacent cell in D, i need to lookup the value in B for the first number

that occur for that month (in this case 4-Jan and so, the number should be

30). I tried various formula but as there are no 1-Jan in column A, it

returns the value of 50 (31-Dec). Anyone here has a solution for this? Thanks