title: Skip the first occurence of a vlookup
body: <p>I'm trying to do conditional formatting with a vlookup. The problem is that I don't know how to skip the first occurrence of the vlookup if the value that the vlookup is not the one that I want. </p>
  
  <p>For example :</p>
  
  <pre><code>a      5
  b      2
  c      9
  a      3    
  d      4
  </code></pre>
  
  <p>Here is a table I'm looking in column A the value 'a' but if the value in column B is not '3' then I want to check the second occurrence of the value 'a' then it rechecks if the value in column B is equal to '3'.</p>
  
  <p>I don't know if I'm clear but any help is welcome. Thank you!</p>
  
  <p>I also tried the combo index and match.</p>