Not knowing much about the structure of your sheet other than what I've been able to decipher from your post, here's my first stab at it...
If the headings of your columns (i.e. row 1) are dates, you can do an HLOOKUP:
=HLOOKUP(DATE(YEAR(NOW()),MONTH(NOW())-1,1),C1:N9,9,FALSE)
Basically, the HLOOKUP looks for the date that is one month previous to now. Of course, this won't work so well when it's January and it looks for a month=0.
Attached is test.xlsx illustrating how this is done.
|