Search code examples
excelworksheet-function

Dynamic cell access

My question may seem quite simple but I haven't found the answer yet.

In excel, I would like to access a cell with a dynamic row number.

Example 1 : cell A(1+2)
Example 2 : cell B(ROW(A1)*10)

What is the syntax for this ?

Thanks.

Solution

  • Use the INDIRECT function:

    =INDIRECT("A" & (1+2))
=INDIRECT("B" & ROW(A1)*10)