You have a range of d3:D62 which is 60 cells. Yo can only have an index of
60 cells. You start to get the REF errors when the index becomes larger than
60.
I went to the menu Tool - formula auditing - Evaluate formula to find the
reson for the error.
"please_post_to_groups" wrote:
Greetings All
sorry if this the second post the first one never made it through...gremlins in the system
Im getting a strange #ref error message in excel and Im not sure
why. Everything works great up to cell and row. but when I get past
that the #ref error pops up. Is this a limit to excel 2003? Anyone
have any workarounds or recommendations?
The code I start to get the error at is =INDEX($D$3:$D$62,2*ROWS
($1:31)+COLUMNS($D:D)-2)
An image can be found at http://test.onewithall.net/problem/excel_problem.jpg
or the Excel file can be found at is http://test.onewithall.net/problem/excel_problem.xls
Tia sal2