•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to xlookup/indexmatch columns with imperfect data?
Please help me. I have 2 columns with names from 2 different data sources and I’m trying to reconcile them.
Ones “first last” and the other is “Last, First”
The problem is that the data is not uniform and I have no control over it. There are a bunch of duplicates, misspellings, etc. One column might say “M&S” and the other “Projected M&S”
How do I use xlookup/indexmatch to reconcile these? I tried making a concatenation key but again the data is not uniform.
Is there another function or workaround I’m not thinking about?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#xlookup
#indexmatch
#data reconciliation
#imperfect data
#data sources
#name matching
#duplicates
#misspellings
#concatenation
#first last
#Last, First
#Excel
#workaround
#function
#data uniformity
#key field
#M&S
#Projected
#data cleaning
#string matching