Formula not copying down
 

I am currently trying to copy a formula down for a total of 734 rows and
across several columns. For some strange reason it stops at 641 rows. Once
I drag the formula in, the cell is just blank. I have tried a new worksheet
and also tried retyping the formula. Nothing works.

I have used this formula before in a much larger worksheet with thousands of
rows. Does anyone have any clue why this may not be working?

The formula is as follows:

{=INDEX('Grant Age by Date'!$I$10:$DK$734,MATCH('Vesting
Schedule'!$B10,'Grant Age by Date'!$B$10:$B$734,0),MATCH('Vesting
Schedule'!L$8,'Grant Age by Date'!$I$8:$DK$8,0))}

Thanks!

Formula not copying down
 

Well, this is an array formula. Are you hitting CTRL+SHIFT+ENTER after you
have defined your range?
--
Brevity is the soul of wit.


"LizM" wrote:

I am currently trying to copy a formula down for a total of 734 rows and
across several columns. For some strange reason it stops at 641 rows. Once
I drag the formula in, the cell is just blank. I have tried a new worksheet
and also tried retyping the formula. Nothing works.

I have used this formula before in a much larger worksheet with thousands of
rows. Does anyone have any clue why this may not be working?

The formula is as follows:

{=INDEX('Grant Age by Date'!$I$10:$DK$734,MATCH('Vesting
Schedule'!$B10,'Grant Age by Date'!$B$10:$B$734,0),MATCH('Vesting
Schedule'!L$8,'Grant Age by Date'!$I$8:$DK$8,0))}

Thanks!

Formula not copying down
 

Yes.

"Dave F" wrote:

Well, this is an array formula. Are you hitting CTRL+SHIFT+ENTER after you
have defined your range?
--
Brevity is the soul of wit.


"LizM" wrote:

I am currently trying to copy a formula down for a total of 734 rows and
across several columns. For some strange reason it stops at 641 rows. Once
I drag the formula in, the cell is just blank. I have tried a new worksheet
and also tried retyping the formula. Nothing works.

I have used this formula before in a much larger worksheet with thousands of
rows. Does anyone have any clue why this may not be working?

The formula is as follows:

{=INDEX('Grant Age by Date'!$I$10:$DK$734,MATCH('Vesting
Schedule'!$B10,'Grant Age by Date'!$B$10:$B$734,0),MATCH('Vesting
Schedule'!L$8,'Grant Age by Date'!$I$8:$DK$8,0))}

Thanks!

Formula not copying down
 

Do you have calculation set to manual?

Tools--Options--Calculation--check automatic calculation. Or hit F9 to
manually force recalculation.

Dave
--
Brevity is the soul of wit.


"LizM" wrote:

Yes.

"Dave F" wrote:

Well, this is an array formula. Are you hitting CTRL+SHIFT+ENTER after you
have defined your range?
--
Brevity is the soul of wit.


"LizM" wrote:

I am currently trying to copy a formula down for a total of 734 rows and
across several columns. For some strange reason it stops at 641 rows. Once
I drag the formula in, the cell is just blank. I have tried a new worksheet
and also tried retyping the formula. Nothing works.

I have used this formula before in a much larger worksheet with thousands of
rows. Does anyone have any clue why this may not be working?

The formula is as follows:

{=INDEX('Grant Age by Date'!$I$10:$DK$734,MATCH('Vesting
Schedule'!$B10,'Grant Age by Date'!$B$10:$B$734,0),MATCH('Vesting
Schedule'!L$8,'Grant Age by Date'!$I$8:$DK$8,0))}

Thanks!

Formula not copying down
 

Yes. But I hit shift F9 and it still does not work. The formula does not
even show up in the cell.

"Dave F" wrote:

Do you have calculation set to manual?

Tools--Options--Calculation--check automatic calculation. Or hit F9 to
manually force recalculation.

Dave
--
Brevity is the soul of wit.


"LizM" wrote:

Yes.

"Dave F" wrote:

Well, this is an array formula. Are you hitting CTRL+SHIFT+ENTER after you
have defined your range?
--
Brevity is the soul of wit.


"LizM" wrote:

I am currently trying to copy a formula down for a total of 734 rows and
across several columns. For some strange reason it stops at 641 rows. Once
I drag the formula in, the cell is just blank. I have tried a new worksheet
and also tried retyping the formula. Nothing works.

I have used this formula before in a much larger worksheet with thousands of
rows. Does anyone have any clue why this may not be working?

The formula is as follows:

{=INDEX('Grant Age by Date'!$I$10:$DK$734,MATCH('Vesting
Schedule'!$B10,'Grant Age by Date'!$B$10:$B$734,0),MATCH('Vesting
Schedule'!L$8,'Grant Age by Date'!$I$8:$DK$8,0))}

Thanks!

Formula not copying down
 

Is the cell protected?

What happens if you copy and paste the formula, as opposed to dragging the
selection to increase the range?
--
Brevity is the soul of wit.


"LizM" wrote:

Yes. But I hit shift F9 and it still does not work. The formula does not
even show up in the cell.

"Dave F" wrote:

Do you have calculation set to manual?

Tools--Options--Calculation--check automatic calculation. Or hit F9 to
manually force recalculation.

Dave
--
Brevity is the soul of wit.


"LizM" wrote:

Yes.

"Dave F" wrote:

Well, this is an array formula. Are you hitting CTRL+SHIFT+ENTER after you
have defined your range?
--
Brevity is the soul of wit.


"LizM" wrote:

I am currently trying to copy a formula down for a total of 734 rows and
across several columns. For some strange reason it stops at 641 rows. Once
I drag the formula in, the cell is just blank. I have tried a new worksheet
and also tried retyping the formula. Nothing works.

I have used this formula before in a much larger worksheet with thousands of
rows. Does anyone have any clue why this may not be working?

The formula is as follows:

{=INDEX('Grant Age by Date'!$I$10:$DK$734,MATCH('Vesting
Schedule'!$B10,'Grant Age by Date'!$B$10:$B$734,0),MATCH('Vesting
Schedule'!L$8,'Grant Age by Date'!$I$8:$DK$8,0))}

Thanks!

Formula not copying down
 

It is not protected and I did try to copy and paste the formula. I also
tried rewriting the formula.

"Dave F" wrote:

Is the cell protected?

What happens if you copy and paste the formula, as opposed to dragging the
selection to increase the range?
--
Brevity is the soul of wit.


"LizM" wrote:

Yes. But I hit shift F9 and it still does not work. The formula does not
even show up in the cell.

"Dave F" wrote:

Do you have calculation set to manual?

Tools--Options--Calculation--check automatic calculation. Or hit F9 to
manually force recalculation.

Dave
--
Brevity is the soul of wit.


"LizM" wrote:

Yes.

"Dave F" wrote:

Well, this is an array formula. Are you hitting CTRL+SHIFT+ENTER after you
have defined your range?
--
Brevity is the soul of wit.


"LizM" wrote:

I am currently trying to copy a formula down for a total of 734 rows and
across several columns. For some strange reason it stops at 641 rows. Once
I drag the formula in, the cell is just blank. I have tried a new worksheet
and also tried retyping the formula. Nothing works.

I have used this formula before in a much larger worksheet with thousands of
rows. Does anyone have any clue why this may not be working?

The formula is as follows:

{=INDEX('Grant Age by Date'!$I$10:$DK$734,MATCH('Vesting
Schedule'!$B10,'Grant Age by Date'!$B$10:$B$734,0),MATCH('Vesting
Schedule'!L$8,'Grant Age by Date'!$I$8:$DK$8,0))}

Thanks!