Try The DGET Function Instead of INDEXMATCH & XLOOKUP

DGET function Excel tutorial and why it's a great alternative to lookup functions!

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:

SOCIALS:

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

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

[ianpaulkenchington]

Hi Kenji! There is also an easy way of dragging an xlookup function in your example:
XLOOKUP(<cell>; <lookup range>; Table[range]) can be changed to:
XLOOKUP(<cell>; <lookup range>; Table["&<cell reference>&"])
That makes XLOOKUP more dynamic

[malkogindrat]

12:04 is the big killer for DGET for most of the situations where you would use XLOOKUP and/or INDEX/MATCH. DGET is for managers...not for data cleaning, mining and stats. The one line example is designed to advantage DGET.

[natecarel]

Thanks for including the section on limitations. It was actually very helpful in understanding the formula itself

[ambrose_vevo]

Your the Best, Kenji i just try to listen to others, how they teach on their chanells ....Your a Good teacher...😊

[driekeijlders]

Nice videos

Trick for you: try using the arrows when you hover the header or first column lines: one click for data next click for header included.

[AbdulRahman-ypoy]

Excellent Kenji, easy explanation, also you teach limitations of formula
Thanks a lot

[faizujutt]

Sir, please make a video on Power Pivot, Data Modeling, DAX, & Relationships.

[Jennakp]

Needed this a lot, saved me at work, but my PC isn't working very well, I might need to get a new PC with or a good Office... driving me CRAZY

[flujensiosserwanji]

Wow this really great. Never heard of DGET before. I was curious seeing the notification. Thank you for the video❤.

[auliakhoirunnisa]

Thank you so much, Kenji! You really make everything related to Excel easier! Been binge-watching all of your videos. Once again, thank you so much! Keep up good work!

[willzinner]

been using excel for a while but first time i hear this formula

[AbdulRahman-ypoy]

Very Thankfull to you ❤
Excellent
Please make videos on Power BI and Power Query

[nkechiizeji]

Please upload part 2 and the remaining parts❤

[ritadwi-mq]

THIS CHANNEL SO MUCH HELP, THANK YOUU SO MUCHHH

[GurpsB]

brilliant video once again! will be purchasing your business guide for sure thanks

[sebastiencrepel]

Very well explained and very useful. Thanks

[markpodesta]

Thank you Kenji. Didn't know about DGET.

[dunghuynhchi]

Thank you for your video, it was very helpful

[williamarthur]

Had forgotten all about Dget and did not realise it was dynamic which is one of the drawbacks the others.

[jazzista]

Joder Kenji.. que buen truco esa funcion de DGET... La voy a comenzar a usar de nuevo.. Gracias