title: EXCEL: Search column for multiple strings, and give cell(s) of mismatch(es)
body: <p>I want to search into an entire column for mismatches (type-errors I made) compared to the available types I've defined. And in case there are any mismatches I want to have the cell of that mismatch displayed in the cell below.</p>
  
  <p>So this is what I have (I replaced the actual types with synonyms for privacy reasons, obviously they aren't named type# irl):</p>
  
  <p><strong>Column E : E</strong></p>
  
  <ul>
  <li>type1   (E1)</li>
  <li>type5   (E2)</li>
  <li>type3   (E3)</li>
  <li>type3   (E4)</li>
  <li>type7   (E5)</li>
  <li><em><strong>tipe2</em></strong>   (E6)</li>
  <li>type9   (E7)</li>
  <li>(E8)</li>
  <li>type3   (E9)</li>
  </ul>
  
  <p><strong>Column K2 : K10</strong></p>
  
  <ul>
  <li>type1   (K2) </li>
  <li>type2   (K3)</li>
  <li>type3   (K4)</li>
  <li>type4   (K5)</li>
  <li>type5   (K6)</li>
  <li>type6   (K7)</li>
  <li>type7   (K8)</li>
  <li>type8   (K9)</li>
  <li>type9   (K10)</li>
  </ul>
  
  <p>For example puposes I made the type-error "tipe2" in cell E6 and also added an empty row in cell E8.
  Now I want a formula which displays "Error" when something in column E:E does not match one of the types in column K2:K10, and else print either nothing or "no error found".
  And at the same time I want in a seperate cell the coordinates (in this case E6) of the mismatching cell.</p>
  
  <p>I've already got the part to get the mismatching cell, where my_string should be replaced with the mismatching string that has been found:</p>
  
  <pre><code>="E"&amp;MATCH("my_string",E:E,FALSE)+IF(COUNTIF(E:E,"my_string")=1,0,COUNTIF(E:E,"my_string")-1)
  </code></pre>
  
  <p>PS: I don't want a VBA script! I just want formulas inside two cells. One to see wether or not I made a mismatch, and incase I did made a mismatch I want the Cell's coordinates (or the last Cell's when multiple mismatches are found).</p>