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

Cloud
1

Hi,

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:

2

Okay I found it: Index function !!!

3

Hello!
We are glad that the issue is resolved.