title: Vlookup with multiple duplicate values
body: <p>I am trying to do a vlookup between 2 spreadsheets. One of the spreadsheet has multiple duplicates... For example: </p>
  
  <p>I have in spreadsheet 1 :</p>
  
  <pre><code>Column A              Column B Column C Column D Column E
  ---------------------------------------------------------
  
  cs_no             Alarmnet1 Alarmnet2 Alarmnet3 Alarmnet4
  ---------------------------------------------------------
  
      FLA013791    
      FLA013791
      FLA013791
      FLA013791
      FLA017564
      FLA017564
      FLA018638
      FLA018638
      FLA018638
      89517190
      89517190
      89517191
      89517192
      89517192
      FLA012274
      FLA012274
      FLA013334
      FLA018635
      FLA018635
  </code></pre>
  
  <p>I have to put the Alarmnet codes in the required spaces from the 2nd sheet </p>
  
  <p>On the second one I have: </p>
  
  <pre><code>Column A Column B
  -----------------
  
  cs-no                    ItemNum
  -----------------------------------
  
  
      89517190       AN547
      89517191       AN547
      89517192       AN547
      89517193       AN583
      89517194       AN583
      89517195       AN583
      FLA012274      AN547
      FLA013334      AN547
      FLA013791      ALARMNETGTC3
      FLA013791      AN548
      FLA016009      AN548
      FLA016927        AN548
      FLA017564        ALARMNETGTC3
      FLA017564        AN548
      FLA017974        AN548
      FLA018075        AN548
      FLA018316        AN548
      FLA018635        AN547
      FLA018636        AN547
      FLA018637        AN547
      FLA018638     ALARMNETGTC3
      FLA018638     AN549
      FLA018639     AN547
      FLA018640       AN547
      FLA018641       AN547
      FLA018642     AN547
      FLA018644       AN547
      FLA018645       AN547
      FLA018647       AN548
      FLA018647       AN560
      FLA018647       AN564
      FLA018648     AN547
      FLA018649       AN547
      FLANT10897      AN547
      FLANT10897      AN554
      FLT43270      AN547
  </code></pre>
  
  <p>If someone can help me out... would be really cool... </p>