Reconciling data sets with slightly different names

[PlasticPearl]

Hi! I'm trying to reconcile two datasets from different sources that have recorded people names slightly differently. For example, one spells it Kolašinac and the other Kolasinac. It's mostly that one is using special characters/accents and the other isn't. Therefore the vlookups and index/match formulas aren't working. I have tried getting around it in some places using "*"&cellref&"*" in the lookup, which has solved some issues but not all. Any suggestions?

 

[alansidman]

Have you tried doing a fuzzy merge in Power Query/Get and Transform? This is found on the Data Tab of the Ribbon.

Fuzzy Match with Power Query - Excel University

Here's how to perform fuzzy matching in Excel using Power Query. Improve your data matching accuracy and efficiency!

www.excel-university.com

 

[PlasticPearl]

Have you tried doing a fuzzy merge in Power Query/Get and Transform? This is found on the Data Tab of the Ribbon.

Fuzzy Match with Power Query - Excel University

Here's how to perform fuzzy matching in Excel using Power Query. Improve your data matching accuracy and efficiency!

www.excel-university.com

Absolutely fabulous thank you. Not a functionality I'd heard of before but this is perfect.