title: Excel formula to search exact mach or substring anywhere in a column
body: <p><strong>EDIT:</strong><br>
  I have 2 column data in excel like this:</p>
  
  <pre><code>A   B
  1   2,3,4
  2   4
  3   5,7
  4   10,9,7
  5   3,6,9   
  8   10,12
  </code></pre>
  
  <p>Can somebody help me write a formula in column C that would get value from the same row of column A and returns true if it exists anywhere in column as an exact mach or a substring.</p>
  
  <p>Result would look like this:</p>
  
  <pre><code>A   B       C
  1   2,3,4   false
  2   4       true
  3   5,7     true
  4   10,9,7  true
  5   3,6,9   true
  8   10,12   false
  </code></pre>
  
  <p>Thanks</p>