[Solved] Value of a cell

[grahamn]

In OOo Calc I have two cells B1 and B2 where I enter various integers and a column (column A) with fixed values.
If the numbers entered into the two cells are, for example, 4 in cell B1 and 10 in cell B2 their product, 4*10, will be 40. I wish to display the value of the cell A(40), that is A(B1*B2), in cell B3
Is there a function or combination of functions that will achieve this or must I go to a macro (which I have not attemted as yet).

[Zizi64]

Code: Select all

=INDIRECT("A"&(B1*B2))

[Villeroy]

=INDIRECT("A"&(B1*B2)) [interprete concatenated text as a reference]
=OFFSET(A1;B1*B2-1) [from reference A1, n rows downwards]
=INDEX(A1:A100000;B1*B2) [nth row within reference A1:A100000]

[grahamn]

Thank you both. INDIRECT was easiest.

[Villeroy]

Thank you both. INDIRECT was easiest.

if the offset is a vertical one

[Lupp]

if the offset is a vertical one

Otherwise

Code: Select all

=INDIRECT(ADDRESS(RowNumber, ColumnNumber))

can be used where RowNumber and ColumnNumber can be given as numeric constants or as any formulae returning numeric (best: integer) results.