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: https://www.careerprinciples.com/courses/excel-for-business-finance

🆓 DOWNLOAD Free DGET Excel file for this video: https://careerprinciples.myflodesk.com/drpsgpln5a

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: https://www.careerprinciples.com/courses/power-bi-for-business-analytics

📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course

🚀 All our courses: https://www.careerprinciples.com/all-courses

SOCIALS:

📸 Instagram - https://www.instagram.com/careerprinciples/?hl=en

🤳 TikTok - https://www.tiktok.com/@career_principles

🧑‍💻 LinkedIn - https://www.linkedin.com/company/careerprinciples/

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

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