title: Why the INDIRECT excel method doesn't work as expected
body: <p>These two methods bring to a different result. Why?</p>
  
  <pre><code>=OR(NOT(ISERROR(SEARCH('[FILTER_OBJECT_SETTING.xlsx]Filter Object'!$A$1:$A$5);A1))))
  </code></pre>
  
  <p>Correct value!! I get TRUE! It works!</p>
  
  <pre><code>=OR(NOT(ISERROR(SEARCH('[FILTER_OBJECT_SETTING.xlsx]Filter Object'!$A$1:INDIRECT("$A$5");A1))))
  </code></pre>
  
  <p>Uncorrect value!! I get FALSE! It doesn't work as expected!!</p>
  
  <p>In A1 there is the following value:</p>
  
  <pre><code>0,"Annotations","10:00:00:00","10:00:08:23","Testo"
  </code></pre>
  
  <p>Instead, in "FILTER_OBJECT_SETTING.xlsx" there are the following values from A1 to A5:</p>
  
  <pre><code>"Abbigliamento"
  "Vestito"
  "Porta"
  "Testo"
  "Statua"
  </code></pre>