Fuzzy Lookup Alternate

[naveeddil]

Dear All,
I'm having a list of Names with about 20,000 which in actualy is about 14000 Names but due to minor mistakes of Data Entry guyz the list got longer and longer.

The List look like below and i have problem in UC names

<colgroup><col style="mso-width-source:userset;mso-width-alt:3657;width:75pt" width="100"> <col style="mso-width-source:userset;mso-width-alt:4169;width:86pt" width="114"> <col style="mso-width-source:userset;mso-width-alt:6253;width:128pt" width="171"> </colgroup><tbody>
[TD="class: xl66, width: 100"] Activity
[/TD]
[TD="class: xl66, width: 114"] District
[/TD]
[TD="class: xl66, width: 171"] UC
[/TD]

[TD="class: xl63"]Administrative[/TD]
[TD="class: xl64"]ABOTABAD
[/TD]
[TD="class: xl65"]ABBOTTABAD WAR
[/TD]

[TD="class: xl63"]Administrative[/TD]
[TD="class: xl64"]ABOTABAD[/TD]
[TD="class: xl65"]ABBOTTABAD WA
[/TD]

[TD="class: xl63"]Administrative[/TD]
[TD="class: xl64"]ABOTABAD[/TD]
[TD="class: xl65"]BAGNOTAR
[/TD]

[TD="class: xl63"]Administrative[/TD]
[TD="class: xl64"]ABOTABAD[/TD]
[TD="class: xl65"]BAGNOTER[/TD]

[TD="class: xl63"]Administrative[/TD]
[TD="class: xl64"]ABOTABAD[/TD]
[TD="class: xl65"]BALDEHREE[/TD]

[TD="class: xl63"]Administrative[/TD]
[TD="class: xl64"]ABOTABAD[/TD]
[TD="class: xl65"]BANDA PIR KHAN[/TD]

[TD="class: xl63"]Administrative[/TD]
[TD="class: xl64"]ABOTABAD[/TD]
[TD="class: xl65"]BAGNOTARE[/TD]

[TD="class: xl63"]Administrative[/TD]
[TD="class: xl64"]ABOTABAD[/TD]
[TD="class: xl65"]BARIN GALI
[/TD]

[TD="class: xl63"]Administrative[/TD]
[TD="class: xl64"]ABOTABAD[/TD]
[TD="class: xl65"]BANDA PIR KHAN[/TD]

[TD="class: xl63"]Administrative[/TD]
[TD="class: xl64"]ABOTABAD[/TD]
[TD="class: xl65"]BARIN GALI[/TD]

[TD="class: xl63"]Administrative[/TD]
[TD="class: xl64"]ABOTABAD[/TD]
[TD="class: xl65"]BARIN GALEE[/TD]

</tbody>

I tried to use fuzzylookup but its not activating in Excel.

Can you please suggest some other solution so that i get same names in other column next to it.


Thank You