Extending Formulas

**mrgillus** · 07-08-2009, 01:39 PM

I want to extend a formula like so- =Sheet2!M3
=Sheet2!M60
=Sheet2!M117

Basically I want it to go up in increments of 57 when I copy the formula down. Is there an easier way to do this rather than typing it over and over again? I looked on an older post and saw some information about OFFSET and INDEX but couldn't figure out exactly how that worked.

Thanks for the help!

**StephenR** · 07-08-2009, 01:54 PM

Not sure about INDEX, but if this were placed in A1 and copied down it should work:

=OFFSET(Sheet2!$M$3,57*(ROW()-1),0,1,1)

**mrgillus** · 07-08-2009, 02:29 PM

Yes, That works. One problem, It does not start at the first box I'm trying to reference which would be Sheet2!M3. Instead it starts at M117 and then copies down from there correctly.

How do I fix it so that it starts at M3 and then goes down?

Thanks again

**mrgillus** · 07-08-2009, 02:34 PM

Okay, I changed it as follows and it starts at the correct cell.
=OFFSET(Forms!$M$3,57*(ROW()-3),0,1,1)

I figured this out although I don't understand how the ROW function works..

Thanks again for your help though!