title: Excel - finding values that "look like"
body: <p>I have an excel workbook with a ton of sheets. In the first sheet "users" i have userdata, firstname, lastname, email, etc. all neatly split from a CSV file.
  In the other sheets, i have some of the names and need the emails from the "users" sheet.</p>
  
  <p>The problem is, that the names on all the other sheets are all in one cell with both first- and lastname like, and in the users-sheet it's split. Also, in the other sheets it might be written as "Mike Anderson", "Mike, Anderson" or even "Anderson, Mike".</p>
  
  <p>Does anyone have an idea to a macro / VBA script / formular, that would help me find and copy the corresponding emails?</p>