Try this formula *anywhere*, and drag across and down,
And see if it meets your specs:

=INDEX($C$7:$IV$1000,5*COLUMNS($A:A)-4,3*ROWS($1:1)-2)

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Sasikiran" wrote in message
...
Hello David...

Thanks a lot.. another query regarding the same..

Now I need to drag the formula =OFFSET(C$7,0,3*(ROW(B100)-ROW(B$100)))
horizontally to the next cell which should refer to C12 (thats *5 rows each
time its dragged horizantally) and the row reference ROW(B100) in the above
formula becomes C100 (that means the row reference will be *1 each time its
dragged)

Can a formula be put in B100 which can be dragged horizantally and
vertically with the above specifications..

Thanks in advance...


"David Biddulph" wrote:

=OFFSET(C$7,0,3*(ROW(B100)-ROW(B$100))) and copy down
--
David Biddulph

"Sasikiran" wrote in message
...
Hi,

I have a problem while dragging the formula.

Its better to give an example rather than explaining in the normal way.

I have a formula =C7 in the cell B100 and =F7 in B101..

That means the row number remains the same (7) but the column number
needs
to be dragged in such a way that for each cell dragged down (from B100
to
B110 and so on) every third column should be referred (i.e C7, F7, I7,
L7
so
on...)

Thanks in advance