•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
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]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#Excel alternatives
#rows.com
#real-time data collaboration
#real-time collaboration
#Fuzzy Lookup
#exact matches
#fuzzy matches
#fuzzy match excel add-on
#exact match
#tables
#Account_Name
#Address1
#Address2
#address columns
#ID #
#Name2
#matching criteria