title: How do you copy an array formula down a column in Calc?
body: <p>I have the following array formula in cell <code>B2</code>:</p>
  
  <pre><code>=INDEX($M$2:$O$110;MATCH(1;($M$2:$M$110=C2)*($N$2:$N$110=E2);0);3)
  </code></pre>
  
  <p>and I want to copy it down a column, so I want:</p>
  
  <p><code>B2 {=INDEX($M$2:$O$110;MATCH(1;($M$2:$M$110=C2)*($N$2:$N$110=E2);0);3)}
  B3 {=INDEX($M$2:$O$110;MATCH(1;($M$2:$M$110=C3)*($N$2:$N$110=E3);0);3)}
  B4 {=INDEX($M$2:$O$110;MATCH(1;($M$2:$M$110=C4)*($N$2:$N$110=E4);0);3)}</code></p>
  
  <p>etc</p>
  
  <p>I enter the formula into <code>B2</code>, I press <code>CTRL+SHIFT+ENTER</code>, then I copy the formula down the <code>B</code> column. This only gives me:</p>
  
  <pre><code>=INDEX($M$2:$O$110;MATCH(1;($M$2:$M$110=C2)*($N$2:$N$110=E2);0);3)
  </code></pre>
  
  <p>The relative reference to <code>C2</code> and <code>E2</code> seems to be treated as an absolute reference. I want <code>E2</code> and <code>C2</code> to change. </p>
  
  <p>I'm using OpenOffice Calc, so I have <code>;</code> instead of <code>,</code> in the functions.</p>