title: How to create Excel list from row title including COUNTIF statement?
body: <p>I have created a spreadsheet with the tally function <code>=COUNTIF(E$2:H$41," * "&amp;$A85&amp;" * ")</code>, which is working, but now I would like to add an additional column that lists what groups those tallies occur. </p>
  
  <p>For example, say <code>" * "&amp;$A85&amp;" * "</code> is searching for the word Apple in <code>E$2:H$41</code> and it was found in <code>E17</code>. I would want the title of that row to show. For this case Fruit from cell <code>A17</code>. If there were other rows in which Apple was found, say red, I would like those listed as well.</p>
  
  <p>I have tried using the INDEX command but cannot get the formula to work that way.</p>
  
  <p>Any help is appreciated.</p>