title: Indirect Function returns #REF
body: <p>I am trying to use a match/indirect function to find a specific value for a range of cells on a separate sheet in excel. The A3 value is the sheet number that the function is referencing and the '1' again the sheet it is referencing.</p>
  
  <p>The <code>F1:F4000</code> is the range from the other sheet and the >7.5 is because I am looking for the first value above 7.5 in that range. Here is what I have so far:</p>
  
  <pre><code>=MATCH(TRUE,INDIRECT($A3&amp;"!'1'!F1:F4000"&gt;7.5,0),
  </code></pre>
  
  <p>Any help would be greatly appreciated</p>