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/cour...

DOWNLOAD Free DGET Excel file for this video: https://careerprinciples.myflodesk.co...

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 builtin 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/cour...
The Complete Finance & Valuation Course: https://www.careerprinciples.com/cour...
All our courses: https://www.careerprinciples.com/courses

SOCIALS:
Instagram https://www.instagram.com/careerprinc...
TikTok   / career_principles  
‍ LinkedIn   / 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