title: VBA Arrays - Check strict (not approximative) match
body: <pre><code>If UBound(Filter(myArray, Sheets(i).Cells(1, j).Value, True)) = -1 Then
   'take action
  End if
  </code></pre>
  
  <p>I used this syntax to compare an element found in Cells(1, j) (e.g. "ally") to all the elements of an array (e.g. "mally", "kate", "becks"), and to take action when no exact match is found.
  Trouble is, based on this line of code it seems "ally" is considered as matching "mally" (probably because "ally" is a substring from "mally"), whereas I want "ally" to be recognised as distinct from "mally".</p>
  
  <p>Any help with the syntax as to achieve this? Thank you!</p>