•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Fuzzy Lookup Question- Finding exact matches and fuzzy matches
Our take
In the quest for precise data matching, you may find yourself needing to perform a fuzzy match on the Name columns of two tables while ensuring an exact match on their corresponding Address columns. This scenario poses a challenge, as traditional fuzzy match configurations often do not accommodate dual criteria effectively. However, exploring the capabilities of the fuzzy match Excel add-on could provide a solution. If you’ve encountered success or implemented a creative workaround, your insights would be invaluable to others facing a similar dilemma.
I have two tables. Table 1 contains the columns Account_Name, ID #, and Address1 and Table 2 contains the columns Name2 and Address2.
I want to perform a fuzzy match on the Name columns BUT only if there is an exact match on the corresponding Address columns. Is this possible with the fuzzy match excel add-on, and if so, how is it performed?
I have found that the existing configurations do not work to perform a fuzzy match and an exact match at the same time, but has anyone had any luck with this?
Thanks in advance!!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience