# Parenthesis in a Formula Won't Let The CrossBars Calculate

#### GWee

##### New Member
The formula I'm using is: =INDEX(Sheet1!A:A,2)
The formula is in: Sheet2 A2
I need to repeat the formula down 800 rows.
Automatic Calculation is On.
I selected the A2 cell and clicked and hold the crossbar on right bottom corner and dragged......doesn't calculate down, just copies the A2 cell.

If you take out one parenthesis and the = to test,.....it works! I noticed that formulas with parenthesis don't calculate down, they just copy.

All my formulas calculate down just fine if I don't use parenthesis...that's a bummer.

Does anybody have a fix?

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.
That formula is indexing the same cell, because you tell the formula which row to use. When you fill down it will only change cell references, if not preceeded by \$, What do you want the 800 rows to contain, if you want them to contain the contents of the similar cell on a different sheet just use:-

=Sheet1!A2

And fill down

Apologies if I have got the wrong end of the stick

Andy

very strange post this is
a few words, only examples

A2: = A1
copy down
result
A3: = A2

A2: =(A1 + B1)*2
copied down
A3: =(A2 + B2)*2

A2: =INDEX(sheet1!A:A,2)
will not change when copied down, since it is refering to an entire column

A2: =INDEX(sheet1!A2:A100,2)
copied down
A3: =INDEX(sheet1!A3:A101,2)

wondering what you mean by
If you take out one parenthesis and the = to test,.....it works!
provide an example please (if it is relevant)

doesn't calculate down, just copies the A2 cell
seems like you think that "A,2" is cell A2, but it isn't !!
take a look at the helpfiles for INDEX
=INDEX(array,indexnumber)
the indexnumber is the "relative rownumber"
in this formula
=INDEX(sheet1!A3:A101,2)
you are refering to cell A4 which is the second in the range A3:A101

does this shade some light on the problem ?

kind regards,
Erik

Yes I have used it that Way!

It works fine (=Sheet1!A2) but when I delete the row in Sheet1, Sheet2 gives out #REF!. =INDEX does not do that. Since INDEX is the way to go, I can't fill down with the crossbar, it just copies that cell. I have 800 rows to go and about 10 columns. Thats alot of typing.

andyh69uk said:
That formula is indexing the same cell, because you tell the formula which row to use. When you fill down it will only change cell references, if not preceeded by \$, What do you want the 800 rows to contain, if you want them to contain the contents of the similar cell on a different sheet just use:-

=Sheet1!A2

And fill down

Apologies if I have got the wrong end of the stick

Andy

HOTPEPPER said:
You really should keep this to your original post:

http://www.mrexcel.com/board2/viewtopic.php?t=181022
You really should keep this to your original post:

I started out with the problem #REF, then it was fixed. Then I couldn't get it to fill down correctly as stated. It was better to make another subject line of that problem because the first problem was fixed.

But anyway It's all working now! Thanks for your help!

Replies
2
Views
355
Replies
85
Views
2K
Replies
3
Views
189
Replies
3
Views
1K
Replies
4
Views
159

1,196,498
Messages
6,015,557
Members
441,901
Latest member
joshtfin

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back