title: How do I make a cell equal to the value of the cell address returned from another cell?
body: <p>I am trying to look up where the first non blank cell is in a row and for the cell (lets call it <code>G1</code>) to give back the cell location (lets say it returned <code>D1</code>). This is working fine but now I want to set another cell (lets call it <code>A1</code>) equal to the content that is inside <code>D1</code>. However, setting <code>A1</code> equal to <code>G1</code> only makes <code>A1</code> say <code>"$D$1"</code> and not the content that is within <code>D1</code> itself. Does anyone know how I can do this?</p>
  
  <ul>
  <li><code>G1</code> looks for first non blank cell</li>
  <li><code>D1</code> has content that I need</li>
  <li><code>A1</code> has to be set equal to content within <code>D1</code> and not just <code>"$D$1"</code></li>
  </ul>
  
  <p>Code:</p>
  
  <pre><code>G1=ADDRESS(2,MATCH(TRUE, INDEX((A1:F1&lt;&gt;0),0),0))
  </code></pre>