Hi all,

I am trying to tweek the offset function in an effort to make it more effective for my particular worksheet.
I require the details in a cell positioned to the left of the current cell, whos position is determined by another cell. Eg Cell A1 Contains '4 months' and the '4' determines information about the Offset function.... the layout being shown below.

Name' Months' Jan - Dec' Total' 'Blank' Jan-Dec' Total'

The offset works fine during the period between Jan - Dec HOWEVER because of the total and blank columns (required) I need to make small adjustements so that Offset picks the correct information (Eg +2 etc to miss blank and total). I would like to have some intelligence in this equation so that it can be made more universal.

Any help would be much appreciated!
Cheers
J