Formula to increment indirect references

thanks NBVC but i dont think this is what im looking for,

I think this will populate them with the cell/reference you are working in

eg: if you are typing formula in cell A564 the formila would be =INDIRECT("'0091 911'!"&ADDRESS(564,COLUMN(E$1)))

I need this to populate a grid of values by dates.

So i have a table which has every date for 2008 on the 00091 911 sheet, then on another sheet I have a grid with just space for 31 days with a combo box to shoose the month.

When the month Januart is selected, the cell link for the combo box populates with 1, this is then linked to a vlookup table so the first cell of my grid with 31 rows will populate with the reference on the 00091 911 sheet, so if someone clicks on Febuary, the first box will populate with the indirect reference to the 00091 911 sheet (A32) and then i would need the cells below to populate with A33, A34, A35 of the 00091 911 sheet.

If someone was to click on October the first cell of my grid would populate something like a 276 of the 00091 911 sheet and then i would need the cells below to populate with A277, A278 etc.

I also need this to work for colums

basicly i have a table with a years worth of data (365 rows) and 48 pieces of data for each day.

I want this to be populated into my grid for one month (31 rows, 48 pieces of data each) and this will then feed an automatic graph.

Hope this makes sense

this sounds a lot more confusing than it is,

if cell A1 contains =indirect(C20)

then is there a formula that will look at A1 and make cell A2 populate with =Indirect(c21)

If the value in A1 changes to =Indirect(H750) then the cell in A2 should change to =INDIRECT(H751)

does this make more sense?

ok here is the sheet i want to work on, hopefully this will explain better than me,

or perhaps the formatting of my date, on the 0091 911 sheet they aqre formatted dd/mm/yy ?

That would be great,

Yes the sheet you sent doesnt populate with walues, I dont know if it effects it but removing the +0 from the formula reults in the Iserr function returning a false value, however it still results in a N/A fromt he whole formula

Hi,

yes im still producing blank cells,

Its definately a TRUE return on your Iserr formula because if i change the "" value to "error"

=IF(ISERR(($G$19&" "&ROWS($A$1:$A1)&", 2008")+0),"error",INDEX('0091 911'!B:B,MATCH(($G$19&" "&ROWS($A$1:$A1)&", 2008")+0,'0091 911'!$A:$A,0)))

then all cells populate with "error"

does this help?

lol that's what my gut was telling me, but i hate taking guesses at it! just looking at the data now! looks good so far!

The formula works great!

Thanks for all you help with this!

it is so much better than my original way!