G
Guest
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!
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!