How to make an offset for a reference text value in Excel
<p>I am trying to make an offset for a cell that contains a reference for another cell. I am trying to do the offset for the other cell, and I am using the following </p>

<pre><code>=OFFSET(INDIRECT(CELL("address";H3));1;1)
</code></pre>

<p>in the H3 cell there is; lets say an address for the cell <code>($A$7)</code>, I want to implement the offset at, but the value is always <code>0</code></p>

<p>How can I have the value of the new offset address cell?</p>