title: Excel Formula needed to lookup value in 1 spreadsheet & transfer it to another spreadsheet with the matching value
body: <p>Every week I receive an excel file with approx 2,000 lines in it.  I need to be able to transfer the commission received for each unique stock item into my master file (separate spreadsheet)so that it shows against the same unique stock item.  I have tried using macros (at the moment I manually go through copy &amp; paste to look up in the master file).  I have also tried IF function &amp; VLOOKUP but can't seem to get it to paste the correct commission value.</p>
  
  <p>This is an example of the file I receive:</p>
  
  <pre><code>Stock Number    Customer    Commission Value(Ex VAT)
  8944125460285514045 MISS ASHLEY CONNELLY    9.16
  8944125460285247596 MR ROLAND COOPER    9.15
  8944125460233434510 MISS SHERYL SEELEY  10.25
  8944125460286262784 MISS CLAIRE HARPER  10.23
  8944125460286264392 MS JILL BROWN           10.23
  8944125460285752322 MISS HAYLEY NICHOL  10.23
  8944125460183834545 MR RICHARD OMAHONY  9.91
  8944125460233404356 MISS ALICIA MORAN   9.90
  8944125460326568455 MRS CHANTELLE BILLY 9.89
  8944125460286263303 MRS VANESSA SMITH   9.89
  8944125460285247893 MISS VENISHA MILLER 9.87
  8944125460326089940 MR CRAIG HAINES         9.86
  8944125460285658222 MR JAY DEE          9.84
  </code></pre>
  
  <p>This is a simplified version of my master file:</p>
  
  <pre><code>Stock Number            Customer Name           Comms Rec'd
  8944125460286264392 JILL BROWN  
  8944125460285247596 ROLAND COOPER   
  8944125460233434510 SHERYL SEELY    
  8944125460285658222 JAY DEE 
  8944125460286262784 CLAIRE HARPER   
  8944125460285514045 ASHLEY CONNELLY 
  </code></pre>
  
  <p>I need a formula that will transfer the commission value from the received file to the comms rec'd column of the releveant stock number.</p>