title: Excel search for string
body: <p>What is function to search for a string in an excel cell and have another string displayed in the second cell whether that string was found in the first cell.</p>
  
  <p>For example:</p>
  
  <p>Cell A1 contains text: "This is some sample text" </p>
  
  <p>I have a list of predefined strings in a column in another sheet, and they are: "text, sample1, sample2, string" (all in separate cells)</p>
  
  <p>Cell A2 should then display: text - because the word text exists in cell A1, so basically need to match only specific words from one cell to the other. In real life A1 will have many words but I need to just look for one.</p>