I believe this array-entered** formula will do what you want...

=INDEX(C:C,MATCH(ROW(A1),MONTH(A$1:A$2500)))

** Commit the formula using Ctrl+Shift+Enter, not just Enter by itself

Place the formula in a cell, change the 2500 row reference to the maximum
row number you ever expect to have data in, and then copy it down for 11
more rows.

--
Rick (MVP - Excel)


"travis" wrote in message
...
And by the way there is a related problem which I'm not sure can be
solved as simply as the lookup(big number,range) trick.

I want to produce a table showing the closing account balance at the
end of every month.

There may be no transaction between the 20th and the 3rd, but I'm not
worried about accrued interest so in that case I'd take the value on
the 20th.

This would enable me to show my historical end of month cash levels.

Travis