1 min readfrom 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!!

submitted by /u/amoretzamarro
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article