Match names that are almost the same
VLOOKUP only finds exact matches, so "ABC Ltd", "A.B.C. Limited" and "abc limited" never line up. Fuzzy matching compares names the way a person would, giving each pair a similarity score, so you can match supplier lists, customer databases, CRM exports and bank statements in minutes.
- Cleans names first: Ignores capitals, punctuation, accents and, if you choose, Ltd, Limited, PLC, LLP, Inc and "The".
- Handles word order and extra words: "Partners John Lewis" and "John Lewis & Partners" still match.
- Clear results: Every row is marked Exact, Strong match, Possible match or No match, with the next best suggestion for checking.
- Bring columns across From the master list, just like VLOOKUP, for example the account number or region.
The scores use the same similarity measures as the widely used rapidfuzz library (ratio, token sort and token set), and are checked against it.