title: Exact VLOOKUPs are not acting the same
body: <p>I have this lookup that I'm doing that is giving me fits today.</p>
  
  <pre><code>=IF(ISNUMBER(SEARCH("ONE",(IFERROR(VLOOKUP($E3,'Membership'!$A$2:$S$6500,19,FALSE),"N")))), "ONE", "N")
  
  =IF(ISNUMBER(SEARCH("TWO",(IFERROR(VLOOKUP($E3,'Membership'!$A$2:$S$6500,19,FALSE),"N")))), "TWO", "N")
  </code></pre>
  
  <p>Membership column 19, is a number concatenated to text: 1 ONE; 2 TWO; 3 ONE/ </p>
  
  <p>It's working for ONE but not TWO. Actually, I have seven and it's working for two and not the other five.</p>
  
  <p>I must be too close to the trees.</p>
  
  <p>Any ideas will be highly appreciated!</p>
  
  <p>Please let me know if any additional info is needed.</p>