Fuzzy Search for Excel to compare two similar string using new algorithms
FUZZYSEARCH FUNCTIONS
Fuzzy Lookup Explained = FuzzySearch.FUZZYLOOKUP( value or column to search, Columns to match with, Columns to retrieve, threshold)
Fuzzy Lookup Sample Formula = FuzzySearch.FUZZYLOOKUP( A2:A50, Sheet2!B:B, Sheet2!B:F, 0.75)
Fuzzy Match Explained = FuzzySearch.FUZZYMATCHARRAY( column one to compare, column two to compare)
Fuzzy Match Formula Sample = FuzzySearch.FUZZYMATCHARRAY( A2:A100, B2:B100)
Ensure payment email is the same as email logged on the top bar