formula change problem

C

cparsons

The columns that the formula is referencing can change locations on th
spreadsheet, if a user inserts a new column. To simplify the questio
I put the actual column numbers in the formula but actually I will hav
an integer defined that will hold the column number. That integer wil
get populated by grabbing the column number from a named cell in tha
particular column. I hope I explained that good enough.

I was using the offset's in the formulas because that is what I am mos
familiar with. Can offset's not be used in formulas?

Is there a better way?

Thanks
 
Top