title: Excel INDIRECT not recognizing concatenated value?
body: <p>I have a moderate sized value matrix that collects data (60-80 values/sheet) using INDIRECT function from 50 or so sheets.</p>
  
  <p>As an example:</p>
  
  <pre><code>=IFERROR(INDIRECT($C4&amp;N$1);0)
  </code></pre>
  
  <p>In which:</p>
  
  <p><code>$C4</code> = concatenated value (sheet name). Reason for using the <code>CONCATENATE</code> is that value is combination of IDs for both service provider and sites. These are from data validation lists on separate sheet.</p>
  
  <p><code>N$1</code> references to cell in the sheet to retrieve value from</p>
  
  <p>Problem is that the <code>INDIRECT</code>-function doesn't seem to recognize the concatenated value. </p>
  
  <p>If the situation is as follows and C is concatenated value matching the sheet name the <code>INDIRECT</code> gives value 0 according to <code>IFERROR</code>.</p>
  
  <blockquote>
    <p>| A  |  B  |    C   |   |ISS | HT  | ISSHT  |</p>
    
    <p>A = service provider</p>
    
    <p>B = site name</p>
  </blockquote>
  
  <p>Now if I change that ISSHT to plain text with no <code>CONCANATE</code>-formula the same <code>INDIRECT</code> formula returns the correct value from matching sheet.</p>
  
  <p>Changing the cell data type in Excel has no effect to end result.</p>
  
  <p>Any ideas/help to fix this is appreciated. </p>