Dragging question

MOB

Well-known Member
Joined
Oct 18, 2005
Messages
1,024
Office Version
  1. 365
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Hi

Bit convoluted, but maybe:

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

or:

Code:
=OFFSET($F17,COLUMN(),)

Richard
 

Watch MrExcel Video

Forum statistics

Threads
1,113,955
Messages
5,545,162
Members
410,667
Latest member
Gaexel
Top