index function

  • Thread starter Thread starter Beasley
  • Start date Start date
B

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
 
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)
 
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.
 
Back
Top