[Calc] Index function Error

[ocyp]

Hi all,

I’m making a list using Calc and using Index functions. I realised that the function doesn’t work after the 112th low. Does anybody have same issue? Examples below;

No problem

=INDEX($A$4:$C$115, 1,1)

↓

=INDEX($A$4:$C$115, 112,1)

Error502

=INDEX($A$4:$C$115, 113,1)

[mikekaganski]

INDEX help section tells:

Row (optional) represents the row index of the reference range, for which to return a value

You reference a range of 112 rows: from row 4th till row 115. You have no 113th row in your range.

[ocyp]

Woops, I made a silly mistake! Thanks Mike.