Forum Discussion
Proofing a hotel list
Hi BHamilton50
The master list can be different in a few ways...the names are spelled differently than the names in the initial list
So basically you're trying to compare/match Apples & Oranges. An IF/THEN won't be of any help for this kind of exercise (or I misunderstood what you actually expect), a Fuzzy Lookup can, to a certain extent...
I haven't used the FuzzyLookup add-in for Excel for years so not sure it installs/runs on 365. On the other hand Get & Transform aka Power Query offers that functionnality as well - see Create a fuzzy match (Power Query)
Thank you for your response to this.
I'd say 'kinda' on the apples to oranges comparison. It's comparing 1 list of names to another list of the same names with possibly slightly different variations in some of the names.
Most of the names on both lists, however, do match up, so the differences are probably on a very small percentage of the names.
The information in the details section of the link you sent, though, sounds about what I am looking for.
I haven't tried your solution, but I plan to do that this week.
Thank you so much for what you sent! I'll send an update when I have one.
Hi BHamilton50
Not sure what you looked at but I would recommend the Power Query route
Another recommendation (I had surprises that are difficult to explain...): if names in one or both list(s) contains non-alpha chars., ex.: comma, underscore... start by removing those chars before trying to Fuzzy match
