Forum Discussion

Biggy_E's avatar
Biggy_E
Copper Contributor
Mar 12, 2024
Solved

Help--Formulas

Hello!  I am seeking assistance creating a formula that can cross-reference two data sources.  So the issue is that one set of data has first and last names, and the second source has first name, mid...
Formulas and Functions
  • Rodrigo_'s avatar
    Rodrigo_
    Mar 13, 2024

    Biggy_E 

    Have you heard Fuzzy Lookup? It performs fuzzy matching of your two sets of data/table.

    1. Fuzzy Matching:
      • used to identify similar or approximately matching records in a dataset.
      • Unlike exact matches, where data must be identical, fuzzy matching allows for variations such as typos, misspellings, and similar phrases.
    2. Use Cases:
      • The Fuzzy Lookup Add-In can be used in two main scenarios:
        1. Duplicate Detection: Within a single table, it identifies fuzzy duplicate rows based on textual similarity.
        2. Data Integration: Between two different tables, it performs a fuzzy join to match similar rows.
    3. How It Works:
      • The add-in compares the data/text of specified columns (such as names, addresses, or product descriptions) using advanced algorithms.
      • It assigns a similarity score to each pair of records, indicating how closely they match.
      • You can then set a threshold to determine which pairs are considered matches.

    You can download this fuzzy lookup here>>> Download Fuzzy Lookup Add-In for Excel from Official Microsoft Download Center

    you can use this tutorial based on your query>>> How to Use Microsoft Excel Fuzzy Lookup - YouTube

     

    I've also attached the sample file using fuzzy lookup

     

Rodrigo_'s avatar
Rodrigo_
Iron Contributor
Mar 13, 2024

Biggy_E 

Have you heard Fuzzy Lookup? It performs fuzzy matching of your two sets of data/table.

  1. Fuzzy Matching:
    • used to identify similar or approximately matching records in a dataset.
    • Unlike exact matches, where data must be identical, fuzzy matching allows for variations such as typos, misspellings, and similar phrases.
  2. Use Cases:
    • The Fuzzy Lookup Add-In can be used in two main scenarios:
      1. Duplicate Detection: Within a single table, it identifies fuzzy duplicate rows based on textual similarity.
      2. Data Integration: Between two different tables, it performs a fuzzy join to match similar rows.
  3. How It Works:
    • The add-in compares the data/text of specified columns (such as names, addresses, or product descriptions) using advanced algorithms.
    • It assigns a similarity score to each pair of records, indicating how closely they match.
    • You can then set a threshold to determine which pairs are considered matches.

You can download this fuzzy lookup here>>> Download Fuzzy Lookup Add-In for Excel from Official Microsoft Download Center

you can use this tutorial based on your query>>> How to Use Microsoft Excel Fuzzy Lookup - YouTube

 

I've also attached the sample file using fuzzy lookup

 

Resources