title: query a spreadsheet range and find if data is present
body: <p>I am trying to query Multiple cells that contain keywords separated by commas i.e</p>
  
  <p>,test1,test2,test3,</p>
  
  <p>I am only trying to search for one word at a time (test1) and then return whether or not the word is included in any of multiple cells.</p>
  
  <p>Ideally I will then be able to pull the word if it is included in a cell and also another value from a neighboring cell. I know this can be done using vba but I need this to be functional on an excel online file.</p>
  
  <p>Is there any way this could be done?</p>
  
  <p>Thanks in advance! </p>