title: Matching different name formats
body: <p>I have two data files I need to match:  </p>
  
  <ul>
  <li>The first has Names, Dates, and Hours worked. The names on this are formatted last, first (nickname). eg, <code>Smith, John (John)</code>.</li>
  <li>The second has only names and dates, and needs the hours filled in from the first, if they are listed. This one has a name format of first and maybe middle initial, plus last, as one string. eg, <code>JSMITH</code> or <code>JDSMITH</code>.</li>
  </ul>
  
  <p>I realize if more than one person has the same last name it might be problematic, but is there a way to compare and pull these hours with a formula, or does this have to be a manual process?  </p>
  
  <p>Some of these are upwards of 1500 lines. If possible, I'd like to do this via formula, as no one else in the office knows any VBA. If VBA is the only way, I'll try to figure out a way to make it user friendly.</p>