Copying a formula,

[Keith Blake]

Hi again,
Say I have in D7
=IF(B7="","",INDEX(Paul!D734,MATCH(9.99999999999E+307,Paul!D734))
and I want to copy that formula down from D8 to D34 but I want to keep
D734 (in the formula)THE SAME,
currently it jumps to D835 then D9 to D36 etc
all I want to change is the name of the sheet (EG: Paul (in D7) to Mick (in
D8) to Asher (in D9) etc.
The changing of the name I can do manually, but changing D835 back to
D735 is a major pain!
So basically I want to copy and paste the formula but not have it auto
adjust ? for the new column...
Hope I made myself clear.
Thanks
Keith Blake
(e-mail address removed)

 

[Niek Otten]

Hi Keith,

D8 is a relative address. $D$8 is an absolute address; it will not change
when you copy.
You can either type it, or edit the formula, place the cursor in the address
and press F4.
An even easier way is to use a defined name (Insert>Name>Define) for the
range.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Keith Blake]

Thank You Niek...
Works great...

Hi Keith,

D8 is a relative address. $D$8 is an absolute address; it will not change
when you copy.
You can either type it, or edit the formula, place the cursor in the address
and press F4.
An even easier way is to use a defined name (Insert>Name>Define) for the
range.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel