ONLYOFFICE Docs v6.4 with conditional formatting, new scaling options, and WOPI protocol support
ONLYOFFICE Docs v6.4 released

[calc] help! get the value of a cell whose position is calculated


In my A column I have a list of cells with different words inside.
I get a random number in cell E1.
In another cell I want to get the value of the cell A at row E1.
for instance if E1 value is 5, I want to get the value of cell A5. If E1 is 24, I want to get A24.
I tried =A(E1) =A[E1] =A$E$1, doesn’t work.

How can I do that?

THX :slight_smile:

Okay I found it: Index function !!!

We are glad that the issue is resolved.