title: Excel - See if cells in one column contain text from another
body: <p>Currently I am using the below to see if cells in column B exist in Column A...</p>
  
  <pre><code>=IF(ISERROR(MATCH(B1,A:A,0)),"False","True")
  </code></pre>
  
  <p>... However I've just realised the need to not check for an exact match, but rather if the cells in column B contain text that appear in any of the cells in column A.</p>
  
  <p>For example, if a cell in column B contains "TIC081_CL1" then I could return "true" if column A contains a cell with only "TIC081"...</p>
  
  <p>Can anyone help me with this please, as my current working only works for eact matches. Many thanks for any assistance!!!</p>