On Oct 15, 11:53*pm, travis wrote:

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


Actually, I figured this one out for myself.

Inspired by your lookup idea, I found that
vlookup(EOMonth(date),range,offset,TRUE) gave me the answer I was
looking for.

Travis