title: match if statement excel
body: <p>I am trying to match termed employees in column c with against a master list of all firm emoployees in column e with the following:</p>
  
  <pre><code>=IF(MATCH(C2,$E$2:$E$13691,0),"N", "Y")
  </code></pre>
  
  <p>The formula returns N correctly but instead of a Y I get the #N/A ref error. <br>
  Any ideas?</p>