title: Vba Find Exact match
body: <p>Im trying to make VBA code to find columns with specific header and then perform some calculations on that column. My problem is that i have to look for specific words. In my case i have column headers like this:</p>
  
  <pre><code>Parametric STD-1 randomnumbers
  Parametric STD-2 randomnumbers
  STD-1 randomnumbers
  STD-2 randomnumbers
  </code></pre>
  
  <p>Its easy to find Parametric STD-1 column address but when i look for STD-1 it will find Parametric. Problem is that i cant use exact match parameter because after STD-1/STD-2 there are some randomnumbers. </p>
  
  <p>Do You have any idea what i could do to always find correct column address?</p>