Referencing in "name" function in Calc

[Stasio]

Hi everyone,
I´m building a spreadsheet with formulas referencing to cell ranges as “names” - like this:

I have a formula in a column
=max(name01)
=max(name02)
etc…

the result is max values of the range coresponding to the particular name - all good, but I´d like to write the formula in more flexible way like =max(nameXY) whilst XY numbers will be specified in another column. I tried whatever, but I can´t figure out how to achieve this seamingly easy task. Any ideas?

Thanks!

[LeroyG]

=MAX(INDIRECT("name"&cell reference) where “cell reference” is the name of the cell with the XY number (i.e., A1).

LibreOffice help on INDIRECT.

[Stasio]

oh man, you´re the God!!! That works perfectly. Thank you. I was literally so close by myself but this totally makes sense.

[LeroyG]

@Stasio

you´re the God

No, just a man learning a bit.