Text mining and content categorization

Fuzzy Matching

Reply
Occasional Contributor
Posts: 7

Fuzzy Matching

Hi,

 

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

 

Example:

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

Grand Advisor
Posts: 16,875

Re: Fuzzy Matching

Ask a Question
Discussion stats
  • 1 reply
  • 441 views
  • 0 likes
  • 2 in conversation