index function

[Beasley]

I have a formula for a cell =INDEX(C5:I324, X5-D5+1, 3)
and I'd like to copy and paste this while keeping my
array (C5:I324) the same. When I paste this, it changes
my array to, for example, C6:I325 for the next cell
down. How do I paste and keep the array the same.

Thanks,

Beasley

 

[Peo Sjoblom]

In the formula toolbar select the array (highlight), press F4, then enter.
Or manually insert dollar signs like $C$5:$I$324 (the first trick will do
that automatically)

 

[Ragdyer]

Change your addresses from relative to absolute by inserting dollar signs
($) before each Row and Column.

=INDEX($C$5:$I$324, X5-D5+1, 3)

You can accomplish this rather easily by clicking in the address in the
formula bar and then hitting F4.