There is a way to create a relative cell according to the value of another?

[cvillaronga]

I need to create a cell so that the row number is equal to the value of another cell
= $ x ($ anothercell)

As a macro substitution, it is possible to do that?

[mariosv]

You can do it with INDIRECT() and OFFSET functions. See the help for more detail.