VLOOKUP sucks: Excel non matches, duplicates, fuzzy match ++
HTML-код
- Опубликовано: 12 июл 2024
- VLOOKUP has been Excel's 3rd most used function for decades up to 2020, but it has shortcomings, in this video I showcase other methods to join tables including: XLOOKUP (VLOOKUP but easier and more powerful), TEXTJOIN with IF to match with duplicates, Power Query for different table join types, matching based on 2 columns and fuzzy matching (e.g. match Brazil to Brasil) and lastly Power Pivot to create Pivot table analysis based on multiple tables of different granularity.
You can download the example files here: www.xlconsulting-asia.com/you...
Chapters:
00:00 Introduction
01:47 XLOOKUP
03:41 TEXTJOIN IF for duplicates
04:55 Non matches: Power Query joins
08:59 Fuzzy matching similar text
12:13 Merge based on 2 columns
15:05 PowerPivot Авто/Мото