title: Excel INDIRECT returns with REF error
body: <p>I don't understand why my INDIRECT function does not work. I'm dynamically changing D2 value from a list.</p>
  
  <pre><code>=INDIRECT("'G:\Production\OPH 2015\"&amp;D2&amp;"'!"&amp;"G4")
  </code></pre>
  
  <p>where </p>
  
  <p>D2 = [Spreadsheet.xslx]Sheet1</p>
  
  <p>G4 would be the value I want the formula to return with.</p>
  
  <p>The same formula on its own returns the value 72.2% and looks like this:</p>
  
  <pre><code>='G:\Production\OPH 2015\[Spreadsheet.xlsx]Sheet1'!G4
  </code></pre>