libreoffice calc - How to refer to a cell when the address is in a variable -

for example, in expression, instead of writing address a1, how can write like: a(b1) b1 = 1.

i think way of explaining indirect way:

it turns text range, if range valid.

e.g. if have text a1, it'll reference a1. if have text c2:c100, you'll range.

now, 1 of common ways in excel generate text in form of ranges concatenate. if concatenate a , 1 (concatenate("a","1")), a1.

and can use reference in concatentate. let's cell b1 contains 1.

=concatenate("a",b1)

gives text a1.

hence, cell a1, able use:

=indirect(concatenate("a",b1))

except concatenate() function bit long, don't fret! can use &:

=indirect("a"&b1)

works well.

if have more complex have c in a1 , 32 in b1, refer cell c32, can do:

=indirect(a1&b1)

which gives =indirect("c"&"32"), =indirect("c32") , =c32

Bradly