title: Using indirect within an array
body: <p>I'm trying to use an array formula which has an indirect within it.  The formula returns #VALUE however if I solve the 'indirect' portion of the array using F9 then solve the rest of the array, it works.  Any ideas?</p>
  
  <p>The following is the formula, hopefully this is helpful without the raw data:</p>
  
  <pre><code>=SUM((dat = x)*(dat)*(INDIRECT(ADDRESS((MATCH(dat)),MATCH(dat))))
  </code></pre>