title: Using the Concatenate function in an IF statement
body: <p>I am trying to find a string in excel cells, and it works to some extent, but when the value returns false I simply get "FALSE" in the cell, although when it returns a true value it actually changes the cell to what I have defined in the <code>IF</code> statement.</p>
  
  <p>Is this because I have inserted the concatenate query incorrectly in the if statement?</p>
  
  <p>My formula is as follows:</p>
  
  <pre><code>=IF(ISNUMBER(SEARCH(ET2:ET4,B2)),"yes",F2=CONCATENATE("NA ",B2))
  </code></pre>