title: Match and align Excel data from various columns
body: <p>I have seen lots of questions similar to this; but none that would work with my data.</p>
  
  <p>Please, feel free to direct me to the appropriate thread - I have tried and failed to find one!</p>
  
  <p>I have two product lists, this one (which is from the website):</p>
  
  <pre><code> BC SKU   BC Product   BC Price   BC Cost
   0        Product xx   £130.50    £86.93    
   0        Product xx   £0         £0       
   10       Product xx   £5         £15.10    
   149      Product xx   £1.35      £2.10     
   188      Product yy   £21.89     £23.89    
  </code></pre>
  
  <p>And this one (which is from the manufacturer):</p>
  
  <pre><code>NVS SKU   NVS Product  NVS Cost
  61        product xx   £269.86
  97        product xx   £282.32
  188       product yy   £24.62
  </code></pre>
  
  <p>The list from the website has around 5,000 entries, and the manufacturer has around 15,000.</p>
  
  <p>I would ideally like a list that would combine the products information, but only for products found on both lists (ie, products that are being sold on the website).</p>
  
  <p>The perfect end result would be:</p>
  
  <pre><code>BC SKU   BC Product   BC Price   BC Cost   NVS Cost   NVS SKU
  188      Product yy   £21.89     £23.89    £24.62     188
  </code></pre>
  
  <p>As you can imagine, the products will have to be matched via the SKU as the Product titles are slightly different. The product SKU's are the only thing that match.</p>
  
  <p>Can anyone help - I'm punching slightly above my weight here?</p>