title: Excel formula to return value instead of TRUE or False
body: <p>I am very newbie in excel, I wanted to make my formula to return matched value instead of TRUE/FALSE</p>
  
  <pre><code>=NOT(NOT(SUM(--NOT(ISERR(SEARCH($D$2:$D$21;$B2))))))
  </code></pre>
  
  <p>is there anyway this formula can be revised to return like for example: found word "wow" and return the word into the cell instead of TRUE/FALSE?</p>
  
  <p>thank you</p>