title: VLOOKUP partial names and with typing or spelling errors
body: <pre><code>Column A - full names 
  Column B - first names
  Column C - surnames
  </code></pre>
  
  <p>Goal: find people in both lists (list 2 has its names split into 2 columns*)</p>
  
  <p>Problem: can't search for a surname from a full name, and names are misspelled or typed wrongly, example</p>
  
  <pre><code>Column A: Jack Doyle
  Column B: Jack
  Column C: Doyles
  </code></pre>
  
  <p>I've got something like the following for looking up the first name (even if this name was Jackson), but I can't figure out the wildcard/LEFT/RIGHT for the surname, especially considering the known errors.</p>
  
  <pre><code>=VLOOKUP(LEFT(B138,4)&amp;"*",A$1:A$999,1,FALSE)
  </code></pre>
  
  <p>I've tried wildcards before and after, a tilde, just not sure where to go...</p>
  
  <p>*Speaking of this, is there an easy way to append a bunch of surnames to first names in back-to-back columns? A=Jack,B=Doyle,C=Jack Doyle (must have the space obv)?</p>