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.
Use the INDIRECT function:
=INDIRECT("A" & (1+2))
=INDIRECT("B" & ROW(A1)*10)