title: #REF error when using INDEX function
body: <p>I cannot understand why everytime I use INDEX in excel to find a value given the two criteria, I get a #REF error. </p>
  
  <pre><code>INDEX(C2:L1048576,MATCH(O1,A2:A1048576,0),MATCH(O2,B2:B1048576,0))
  </code></pre>
  
  <p>There were no deleted cells, nor were they shifted at any point in time. They have the same number of rows too. The arrays to search into are correct. </p>
  
  <p>Thanks. I would appreciate if anyone can give me some guidance. I am new to the INDEX formula. </p>