title: How to find the match between text that typo in Excel?
body: <p>I have two columns of data with an hundred names on and I need to find the matches. </p>
  
  <p>The problem is when names on the second column are not exactly the same as the first column. Its hard to match them with a hundred names.</p>
  
  <p>Is there any formula in excel for at least give tolerance with the data like "Setyadi" with "Setiadi", or "Tak Jelan" with "Tak Lejan".</p>
  
  <hr>
  
  <p>Thanks for the solution, it works, I edited this because I want to ask more,</p>
  
  <p>I have another problem, could you help me again?
  I have a data like this, I want to fill column C with a number according to match the name in column D with column A. The other problem is, I want to match the name that only in a group that mentioned in column E, even not in the same row.</p>
  
  <p>From</p>
  
  <pre><code>    A       |  B  |  c  |     D       |  E   |
   Setyadi    |  1  |     |  Setiadi    |  11  |
  Tak Jelan   |  2  |     | Tak Lejan   |  11  |
    Gordon    |  3  |     |   Herik     |  12  |
     Alex     |  4  |     |  Goerdon    |  12  |
     Heri     |  5  |     |   Alex      |  12  |
  </code></pre>
  
  <p>Into</p>
  
  <pre><code>   A        |  B  |  c  |     D       |  E   |
  Setyadi     |  1  |  1  |  Setiadi    |  11  |
  Tak Jelan   |  2  |  2  | Tak Lejan   |  11  |
   Gordon     |  3  |  5  |   Herik     |  12  |
    Alex      |  4  |  3  |  Goerdon    |  12  |
    Heri      |  5  |  4  |   Alex      |  12  |
  </code></pre>
  
  <p>What I need is, how can we compare the name in group that mentioned in column D, then We can automatically give the number in column C that coupling from column B.</p>
  
  <p>Thanks in advance</p>