Text mining and content categorization

Fuzzy Matching

Occasional Contributor
Posts: 7

Fuzzy Matching



I need code to fuzzy Match on two lists of address "LookIn" list in Col A "LookFor" list in ColB on sheet1, both list are different in the shape. Some times Col A is longer then Col B sometimes the opposite is true. Col A is the master list an Col B where a match exists is either a exact match or a misspelling or a different way writing the name e.g



ColA                                                                  ColB 

NRI Complex, Palm Beach Raod, Nerul           NRI Complex, Seawoods ,Nerul 



I have tried doing FuzzyMatching with help of function (COMPGED, Soundlike) but showed inconsistent results. I need where there is a fuzzy match to have best matches placed in the adjacent cells in the same row next to the cell that was matched, all exact matches can be ignored


I have uploaded a file to demonstrate what I am hoping for..


Thank you

Super User
Posts: 22,820

Re: Fuzzy Matching

Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation