Ask Your Question
0

[Calc] Index function Error

asked 2019-08-29 07:10:53 +0100

ocyp gravatar image

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)

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2019-08-29 07:15:22 +0100

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.

edit flag offensive delete link more

Comments

Woops, I made a silly mistake! Thanks Mike.

ocyp gravatar imageocyp ( 2019-08-29 07:28:05 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-08-29 07:10:53 +0100

Seen: 27 times

Last updated: Aug 29