title: Finding changing text in Excel or Google Spreadsheet
body: <p>hope you can help with an Excel or Google Spreadsheet question.
  In one column I have different words, which I would like to search for in a certain area in the spreadshet. Fx. is B3 present from B50:B678 is B4 present from B50:B678 and so on. The text is not an exact match. That means that sometimes the searchwords is placed in the whole sentes. See this data for an excample: <a href="https://docs.google.com/spreadsheets/d/1MX8WsnwcxEety-sv2ttEcUqgAgEUbpUd_xD18cG20lk/edit#gid=574850130" rel="nofollow">https://docs.google.com/spreadsheets/d/1MX8WsnwcxEety-sv2ttEcUqgAgEUbpUd_xD18cG20lk/edit#gid=574850130</a></p>
  
  <p>Hope you can help. With no succes I have tried these formulas:
  =ifError(filter($B$775:$B$7887,ifError(search(B4,$B$775:$B$7887),false)))
  =IFERROR(IF(UNIQUE(FILTER(B776:B7888,B776:B7888=B3))="text","Found","Not Found"),"Not Found")
  =search(B3,J3:J98) </p>
  
  <p>But the formulas don´t work if there is no excact match...Hope you can help
  Best regards
  Kåre Kildall Rysgaard
  Datajournalist, Analystik.dk</p>