title: Same Formula responds multiple different ways
body: <p>I created a formula that doesn't always act the same way. The reason I say that is I've copied and pasted from multiple columns and it works one way and then another. </p>
  
  <pre><code>{=IF(ISERROR(INDEX('ODG Jobs'!$A$1:$Q$150,SMALL(IF('ODG Jobs'!$C:$C=$B$3,ROW('ODG Jobs'!$C:$C)),ROW('ODG Jobs'!$1:$150)),5)),"",INDEX('ODG Jobs'!$A$1:$Q$150,SMALL(IF('ODG Jobs'!$C:$C=$B$3,ROW('ODG Jobs'!$C:$C)),ROW('ODG Jobs'!$1:$150)),5))}
  </code></pre>
  
  <p>It works to pull data for a duplicate value, but if I try to drag the formula it won't drag properly or it will mess up the formula. I understand to press <kbd>shift</kbd> + <kbd>ctrl</kbd> + <kbd>enter</kbd> to get the array, but the same formula acts in two different ways is confusing. </p>