#ExcelFormulas #FuzzyLookup #DataIntegration

Fuzzy Lookup Saved 20,000+ Records Without a Key

Name: Fuzzy Lookup Saved 20,000+ Records Without a Key
Uploaded: 2026-10-20T22:08:20+00:00
Duration: 1 min 20 s
Description: When you're integrating two systems with no shared identifier, fuzzy lookup becomes your secret weapon. Watch how Stephen handled a real acquisition scenario—matching 7,000 product SKUs and 20,000 customers across different naming conventions with 95% accuracy, cutting days of manual work down to hours. Learn this essential Excel technique for your toughest data reconciliation challenges.

1:20 · A clip from Excel Accounting Tools: Most Useful Formulas and Pivot Tables, taught by Stephen Yoss

When you're integrating two systems with no shared identifier, fuzzy lookup becomes your secret weapon. Watch how Stephen handled a real acquisition scenario—matching 7,000 product SKUs and 20,000 customers across different naming conventions with 95% accuracy, cutting days of manual work down to hours. Learn this essential Excel technique for your toughest data reconciliation challenges. From the course “Excel Accounting Tools: Most Useful Formulas and Pivot Tables” (4 CPE credits, Specialized Knowledge, Basic): https://www.cpetoday.com/course/excel-accounting-tools-most-useful-formulas-and-pivot-tables-25c01231 Taught by Brian Tankersley — Speaker & Author, K2 Enterprises. More from Brian Tankersley: https://www.cpetoday.com/instructor/brian-tankersley CPE Today offers live webinars, Live Replays and self-study for CPAs and accounting professionals. NASBA-sponsored (ID 167619) and an IRS-approved CE provider. https://www.cpetoday.com/ #ExcelFormulas #FuzzyLookup #DataIntegration

More from this course

3:07 Create Custom Groups in Pivot Tables Without Original Data

3:59 Why I Still Use OLD Excel Formulas (Not the Modern Ones)

4:01 Structured References: Name-Based Formulas Instead of Cell Positions