title: Find row with multiple search criteria on substrings in VBA
body: <p>I need to find the row where a cell in column <code>B</code> contains two substrings.</p>
  
  <p>For example these Strings in <code>B1:B3</code></p>
  
  <pre><code>A string with Cows
  Cows and stuff
  A string with Chickens
  </code></pre>
  
  <p>I need to find the row <code>B2</code>where the 2 substrings <code>Cows</code> and <code>shit</code> are present.</p>
  
  <p>What i tried so far:</p>
  
  <ol>
  <li>Find formula that doesent do multiple search criteria. :(</li>
  <li><code>=MATCH(1;INDEX((B:B="Cows")*(B:B="shit"););)</code> that doesent do substrings</li>
  <li>A lot other stuff i forgot,</li>
  </ol>
  
  <p>If it is possible i would like a pure VBA solution.</p>
  
  <p>Any ideas on this one?</p>