Cross-Reference Similar Names Between Two Microsoft Excel Lists
Question details
Identify likely matches and genuine exceptions when two Excel lists contain different versions of the same people’s names.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- You need to compare names across two data sources where one list may include middle names, additional surnames, alternate separators, or minor spelling differences.
- Observed behavior
- Exact matching treats harmless name variations as different records, making it difficult to isolate names that need review.
Place each source in a separate Excel table with a clear name column and remove leading or trailing spaces. Decide whether punctuation, hyphens, middle names, and surname order should be treated as acceptable differences before reviewing matches.
Use the Microsoft Excel Fuzzy Lookup add-in to score similar names
Use this option when you need approximate matching between two tables and want a similarity score to help distinguish likely matches from genuine anomalies.
Fuzzy Lookup compares text values approximately rather than requiring identical names. It is useful for records containing extra name parts, alternate spellings, or slightly different surname formats.
Select the first list, then choose Insert > Table and confirm that the name column has a header. Repeat this for the second list, and give each table a recognizable name from Table Design > Table Name.
Install the Microsoft Fuzzy Lookup Add-In for Excel if it is not already available. In Excel, open the Fuzzy Lookup tab on the ribbon and select Fuzzy Lookup.
In the Fuzzy Lookup pane, select the first table as the left table and the second table as the right table. Add the relevant name column from each table to the matching columns area.
Choose an appropriate similarity threshold, then select Go. Review the generated output table, including the similarity score, and investigate lower-scoring matches or records with no match.

Use a Microsoft 365 dynamic-array formula to list unmatched name variations
Use this option when your lists are in worksheet ranges and you want a formula-based report of names whose component words do not appear in the other list.
Review Similar Names Across Two Lists with WPS Spreadsheet
WPS Spreadsheet can help you prepare and compare name lists by standardizing text, splitting name components, and flagging records for review with worksheet formulas. This is useful when you need a lightweight way to identify likely naming differences before validating the underlying records.
- 1. Open the two name lists in WPS Spreadsheet: Open the Excel workbook in WPS Office, or create a worksheet and place each source in its own labeled column or sheet.
- 2. Standardize the name text: In a helper column, use formulas such as =TRIM(A2) and =UPPER(TRIM(A2)) to remove extra spaces and make capitalization consistent.
- 3. Split names into comparable parts: Select the name column, then choose Data > Text to Columns and use spaces or another appropriate delimiter to separate name components into helper columns.
- 4. Flag names for review: Use Find & Replace to standardize known variations, then apply Data > Filter to helper columns and review rows where key name components do not align between the two sources.

Frequently Asked Questions
Can Excel match names when one list includes a middle name and the other does not?
Yes. Fuzzy Lookup can return approximate matches and similarity scores, while a Microsoft 365 component-based formula can ignore harmless differences by checking whether the meaningful name words appear in the other list.
What similarity score should I use in Excel Fuzzy Lookup?
Start with a higher threshold to reduce false matches, then lower it gradually if valid variations are being missed. The best threshold depends on how common the names are and how many spelling variations your data contains.
How can I compare names separated by commas or hyphens?
Normalize the separators before comparison or include them in the delimiter array of a TEXTSPLIT-based formula. In WPS Spreadsheet, you can also use Data > Text to Columns with the relevant delimiter.
Why do exact Excel formulas report matching people as unmatched?
Exact formulas treat extra middle names, additional surnames, punctuation, spacing, and spelling differences as distinct text. Use Fuzzy Lookup or split and normalize the name components before comparing them.




