Offset function problem - returns circular reference

[busyknitter]

I am using the Offset function on a budget report template that I have set up.

I want Column C to show my client's budget for the current month, with different budget headings down the rows.
The budget isn't profiled evenly, so I have set each month's budget out in columns N to U (I only need to cover an 8 month period, which happens to be months 5-12 of the client's financial year)
The current month is identified in cell K1 as a number; for example February is referenced as 6.

In column C, I have the following OFFSET formula =OFFSET(M10,0,$K$1-4)
So in February, it should return the number in cell O10.

Which it does, but it also returns a circular reference and I cannot work out why.

[:) Sixthsense :)]

I am not clear what is the use of $K$1 in your below formula
=OFFSET(M10,0,$K$1-4)

Your formula doesn't involve any calculations why not simply you refer it to O10 cell like this

Please Login or Register  to view this content.

Or in your way...

Please Login or Register  to view this content.

I am not seeing anything in your formula to cause circular reference. What is the cell reference it is showing in the circular reference error?

[busyknitter]

Sorry if I wasn't clear enough before, thanks for having a look at it.

K1 refers to the month of the financial year as a number. So, September is 1, October 2 etc. I am wanting to report for each month in an 8 month period between January and August and return the specific budget for that month into column C. So when reporting for February I want to show the value from Column O, but in March I will need to show the value in column P...and so on.

As I am reporting across many lines and multiple sheets for this client, I want to tell the spreadsheet that it is Month 6 (or whatever) only once. And that is what $K$1 is for.

I have absolutely no idea why it is showing a circular reference either. It's referencing C10, which is the cell where the answer should be.
I have even removed all the OFFSET functions from the file and started from scratch and it's still doing it.