Fuzzy Matching

[ramesh31]

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

[Reeza]

I like the solution from FriedEgg here:
https://communities.sas.com/t5/SAS-Procedures/Name-matching/m-p/82780/highlight/true#M23757