title: Excel index() Match() and array issues
body: <p>I like working with variables in Excel, it is useful converting everything between commas into a variable, but I got stuck in here, does anyone have an idea how to use array limitations with <code>INDEX()</code> function such as seen in the example?</p>
  
  <p>This is an array formula in a table form:</p>
  
  <pre><code>{=INDEX([@Column1]=[Column1],MATCH(1,([Column2]="Ready"),0),0)}
  </code></pre>
  
  <p>it returns the right value for the first instance of <code>[@Column1]=[Column1]</code> but for the rest, the result is wrong. </p>
  
  <p>A sample can be found in <a href="https://ln.sync.com/dl/a577bc8b0#2kzya6sn-744ev92d-dqpkz4f7-n48w9isv" rel="nofollow noreferrer">>>>here&lt;&lt;</a>&lt;.
  I saved this in another language, please let me know if transcription of functions are incorrect when you open. I tested but..you know.. </p>