title: Find second vlookup value
body: <p>I have the following vlookup formula in Cell J2 of sheet 'SKU DATA' ...</p>
  
  <pre><code>=VLOOKUP(A2,DUPLICATE!C:AJ,34,0)
  </code></pre>
  
  <p>But, in column 34 of the 'DUPLICATE' sheet range there are 2 possible results (there will only ever be a maximum of 2 results).</p>
  
  <p>Vlookup shows the first result ... is there a formula that I can use in cell J3 to show me the second result?</p>
  
  <p>I've looked at several match, index and small functions but, can't get anything to work ?</p>
  
  <p>Thanks</p>