Войти
  • 338281Просмотров
  • 1 год назадОпубликованоKenji Explains

Try The DGET Function Instead of INDEXMATCH & XLOOKUP

DGET function Excel tutorial and why it's a great alternative to lookup functions! 👉 Take our Excel for Business & Finance Course: 🆓 DOWNLOAD Free DGET Excel file for this video: DGET Function: You've probably never heard of the DGET function, yet it's just as useful as the VLOOKUP, XLOOKUP or INDEX MATCH. So we'll compare the DGET function to these 3 super popular lookup functions and also look at how it's better than each of them in specific scenarios. The DGET function also has a built-in wildcard feature, and OR condition, which you'll learn more about in this DGET formula tutorial. LEARN: 🔥Power BI for Business Analytics: 📈 The Complete Finance & Valuation Course: 🚀 All our courses: SOCIALS: 📸 Instagram - 🤳 TikTok - @career_principles 🧑‍💻 LinkedIn - ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00​ -​ DGET vs VLOOKUP 2:17​ - DGET vs INDEX MATCH 4:22​ - DGET vs XLOOKUP 7:15​ - DGET Wildcard Feature 8:59​ - DGET OR condition 10:06​ - DGET Limitations