Dragging question

[MOB]

Hi

I have a formula in cell A1 "=F18" which I want to drag across to cell B1 and I want the formula to be "=F19"

Is this possible? I just get "=G18" of course.............

Thanks

 

[Richard Schollar]

Hi

Bit convoluted, but maybe:

=INDIRECT("F"&17+COLUMN())

or:

=OFFSET($F17,COLUMN(),)

Richard