Hi
I need an Indirect formula to look up data from a different sheet. However, rows may be added to the other sheet so I need that part of the formula to be relative.
On my Summary Sheet I have the formula:

=INDIRECT(C7&"!I"&18)

C7 Is the name of a sheet: "Data1"
I18 contains my value to pick up

This works fine. However If i add a row to my Sheet Data1 my indirect formula stays the same and continues to look to I18 - my data has moved to I19 though.

This spreadsheet has lots of sheets all needing to be looked up and summarised on the Summary sheet.

Anyone come accross this.

love some helo

thanks
Sally