Stop Using XLOOKUP & VLOOKUP. Try This Instead
Om episoden
Episodebeskrivelse
Stop using XLOOKUP and VLOOKUP. Try these two methods instead. 🚀 Get 25% OFF InstaHeadshots here: https://go.instaheadshots.com/kenjiexplains 🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/glvjjgko9e The tutorial goes over the limitations of lookup functions like xlookup and vlookup, and what to use instead. While XLOOKUP and VLOOKUP typically return only the first matching result, the FILTER function can return every match at once. FILTER can also handle multiple criteria using AND or OR logic, and when combined with CHOOSECOLS, you can control exactly which columns are returned. For larger or more complex datasets, Power Query is an even more scalable alternative. Instead of writing multiple XLOOKUP formulas, you can merge tables using a shared field such as Customer ID, bring in several columns at once, identify unmatched records using anti joins, and even use fuzzy matching when names are similar but not identical. LEARN: 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance 📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course 🔥 AI for Business & Finance: https://www.careerprinciples.com/courses/ai-for-business-finance 🚀 All our courses: https://www.careerprinciples.com/all-courses ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00 - Method 1 2:07 - With Multiple Criteria 5:20 - Method 2 (No Formula) 8:22 - Reverse Match 9:48 - Approximate Match (Fuzzy Lookup)
Se mer fra samme kanal
Flere episoder fra denne kanalen
Dette kan interessere deg
