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
