OFFSET formula to act upon value in the cell, not upon cell's address

[2Took]

If cell L1 contains value A20, how do I get OFFSET formula to act upon the value A20 and not upon L1 address?

 

[Leo Skywalker]

Hi,
Try this:

=OFFSET(INDIRECT(L1,TRUE),rows,columns)