title: Excel formula only working on first cell
body: <p>I have  formula i'm trying to use to give me a list of missing items between two cells. For some reason it will only work on the first row but not the rest. If I type in the values manually in the second row, it will work, but that's not an option. I've tried to close and open the workbook and various F9 combinations. Nothing seems to work. </p>
  
  <p><img src="https://i.stack.imgur.com/Uy8gI.png" alt="enter image description here"></p>
  
  <p>Formula: <code>=IF(ISNA(MATCH(A2,[Site Collection Groups],0)),A2,"")</code></p>