INDIRECT function - need help

Originally Posted by dansparts

@bebo

@Richard -

I really don't want to have to "clutter" things up with something like the column offset number.

Can the INDIRECT function not be used?

I simply added the column number to make the formula shorter. If you don't want to include that then just remove the reference to it in the formula and replace it with the number in the formula. So for instance where in E3 i gave you

Formula:

=OFFSET($A$1,(ROW()-2)*14-11+E$2,0)

use instead

Formula:

=OFFSET($A$1,(ROW()-2)*14-11+2,0)

or simpler

=OFFSET($A$1,(ROW()-2)*14-9,0)

Adjust the other cells in a similar way.
This is no different a concept to making the similar adjustment you'd have to do with an INDIRECT() function

Don't get hung up on an INDIRECT.
Personally I generally prefer to use the OFFSET() function, which for many things does the same as an INDIRECT, since it's simpler to understand and usually much shorter.