Hi

I have created a 12 column spreadsheet with January to December headings on row1. Under these on row 2 are numbers in each cell.

In a row 3 cell, what formula should I use to take data from any row 2 cell in columns to the left of that particular cell - e.g. I want to enter under December on row 3, data say from October row2, ie 2 months back but make this a formula which I could easily change to take data from row 2 say 4/5/6months back etc.

Thought It might be an offset formula but can't get it to work
Any ideas would be very welcome.