Support Board

Date/Time: Sun, 19 May 2024 06:24:36 +0000

Post From: SPREADSHEET FORMULA ERROR

[2014-04-30 16:47:07] Link To Thread - Link To Post [Go To First Post]
enemyspy - Posts: 304
SC spreadhseets return the following error: "INDEX WAS OUTSIDE THE BOUNDS OF THE ARRAY" what does this mean? Formula: {=IF(F3=0,"",IF(AND($H3=1,$f3="A"),INDEX($A3:$A$404,MATCH(MIN(IF(h3:h$404=1,$D3:D$404)),$D3:$D$404,-1)),IF(AND($H3=1,$F3="B"),INDEX($A3:$A$404,MATCH(MAX(IF(H3:H$404=2,$D3:D$404)),$D3:$D$404,} I am using the above formula copy and pasted 97 times on top of itself in 1 each cell of a column. Everything is constant in all the duplicates of the formula except for the following statements: IF(AND($H3=1,$f3="A", IF(AND($H3=1,$f3="B", the $h3=1 on both counts up sequentially to $h3=97 with each copy and pasted instance of the formula. Anyone know what is causing this error or how I can fix the syntax?