Thanks much, that should work, other:

(other slight question below)
thanks both !!, would seem to be the right thing.. have to test later, but
wondered if wasn't something alittle simpler than Mod stuff..

as far as selection term goes, I just meant the selection that would occur
from $C$2

what was working on last hour would be a (still not right I think, but
correction on % change formula portion trying to convey, to anyone who
trying to follow, is partial? correction from previous post), is:

=IF(E454=1,IF($C$2=1,EC454/EF454%,
OFFSET(FE454,0,$C$3)/OFFSET(EF454,0,$C$2-1)%),100)-100

Question is this something seen before for part came up with for 1st to IF's,
concept for cascading "IF's", have been using for much longer formula's
have saved much space for many common variables. only pay back I got :)
thanks.



"T. Valko" wrote:

Try this:

=INDEX(range,row,C2*2-1)

--
Biff
Microsoft Excel MVP


"Nastech" wrote in message
...
trying to select every other 1st column, of 2 columns sets.
20 columns, 10 sets. only use one at a time for formula trying to make.
using fixed cell $C$2 to enter 1-10. (first col is a low number, 2nd col
is
hi).
selecting 1 column at a time works for the following example.

=INDEX(E49:X9,1,$C$2)

but for example, need 2 to select column G, 3 column I ..
do I need use of / get help with MOD() ?
thanks.