title: How to use CELL function inside OFFSET function?
body: <p>I am trying below formula:</p>
  
  <pre><code>OFFSET(CELL("address"), 0, -2, 1, 1)
  </code></pre>
  
  <p>Instead this works:</p>
  
  <pre><code>OFFSET($P$20, 0, -2, 1, 1)
  </code></pre>
  
  <p>I do not have the cell reference and so have to compute in formula itself. How to do it?</p>
  
  <p>Thanks in advance!</p>
  
  <p>Niraj</p>