title: Searching for multiple text strings in a MS Excel cell and return the same string when found
body: <p>For example, in Excel cells, I have these texts</p>
  
  <p>A1 "Hi_how_are_you_today_?"</p>
  
  <p>A2 "I_am_doing_great"</p>
  
  <p>A3 "everything good at you workplace?"</p>
  
  <p>A4 "Doesn't have any of these words"</p>
  
  <p>I am looking for 3 words <strong>How</strong>, <strong>Great</strong> and <strong>workplace</strong>. In any cell if any of these words is found then it should return the same word, else it should a return blank value.</p>
  
  <p>I was able to write this formula on Excel but it is returning #N/A error if any of these values aren't found.
  =IFS(ISNUMBER(SEARCH("How",A1))=TRUE,"How",ISNUMBER(SEARCH("Workplace",A1))=TRUE,"Workplace",ISNUMBER(SEARCH("great",A1))=TRUE,"great")</p>
  
  <p>Can we make some changes in this formula so it will return blank if any of these is not found?</p>