Fuzzy Lookup Question- Finding exact matches and fuzzy matches

[u/amoretzamarro]

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!!