title: Matching similar but not exact text strings in Excel VBA projects
body: <p>Okay, I have been trying to find a solution for this and I just don't seem to be able. I can't even break down the problem properly. This is the idea.</p>
  
  <p>I have two sheets with many rows (one with 800 and the other with 300,000). Each row contains a Name column and then several columns that contain information about this Name. Each sheet has different kinds of information. </p>
  
  <p>I want to consolidate these two sheets into a master sheet based on this Name column they both have, so the consolidate function is perfect for this. Now the problem is that the names don't match perfectly.</p>
  
  <p>For example Sheet1 contains </p>
  
  <p>"Company B.V.", "Info #1" <br/>
  "Company Total", "Info #2" <br/>
  "Company Ltd", "Info #3" <br/></p>
  
  <p>and sheet 2 contains </p>
  
  <p>"Company and Co.", "Info #4" <br/>
  "Company and Co", "Info #5"</p>
  
  <p>Sheet 1 contains all the names that are going to be used (around a 100 but in different forms as stated above) and sheet 2 contains all these 100 in multiple rows plus names that aren't in the 100 list and therefore I don't care about. </p>
  
  <p>How would I make a VBA code project where the end result would be something like this, Master sheet:</p>
  
  <p>"Company", "Info #1", "Info #2", "Info #3", "Info #4", "Info #5"</p>
  
  <p>for every single "Company" (the 100 list) in there?? </p>
  
  <p>I do hope there is a solution for this. I'm pretty new to VBA projects, but I have done some minimal coding before. </p>