title: Approximate match lookup - similar text strings in Excel (No VBA & No Fuzzy Match Add-in)
body: <p>Using Excel 2010.  I have two data sets that contain lists of employees.  The data is similar but not exact.  Need to look up if the name in data set A is in data set B.  </p>
  
  <p>Data Set A</p>
  
  <pre><code>John Smith Jr.
  
  Dan Rogers 
  
  Jane Doe
  </code></pre>
  
  <p>Data Set B</p>
  
  <pre><code>SMITH, JOHN 
  
  ROGERS, DANIEL
  
  DOE, JANE
  </code></pre>
  
  <p>Have tried looking up partial match formulas without luck.  Looking for a formula not using VBA or the fuzzy match excel add-in.</p>
  
  <p>Thanks</p>