Adding rows to the data array used in an Index function
 

If I add rows to my data set...

1) Will the array automatically adjust?
2) Will any cells that reference the cells beneath the rows I add
automatically adjust to the new locations? Or will I have to manually go
into every index and update the row number needed??

Thanks!

Adding rows to the data array used in an Index function
 

Excel will update the references if you are using relative references... any
reference with $ in front of row number will not change...

References of type -
A1 will change
A$1 will not change
$A1 will change
$A$1 will not change

References inside INDIRECT won't change...

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Lanhing" wrote:

If I add rows to my data set...

1) Will the array automatically adjust?
2) Will any cells that reference the cells beneath the rows I add
automatically adjust to the new locations? Or will I have to manually go
into every index and update the row number needed??

Thanks!