DGET Function - The Secret VLOOKUP Alternative for Multiple Conditions

In this video, we look at the DGET function - the secret alternative to VLOOKUP for multiple conditions.

This function appears to fly under the radar, yet is incredibly useful. The most well-known alternative to VLOOKUP is the INDEX and MATCH combination, but DGET should also be considered.

The greatest strength of DGET is the ability to handle multiple conditions. By using a criteria range, it is simple to enter multiple conditions.

It relies on the headers matching so can lack the flexibility of other formulas, but the simplicity is a plus.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[supertotoro]

Considering myself a pretty advanced excel user who can write vlookups and index-match statements in my sleep and still have never heard of this. This is amazing, no more helping columns! Love it!

[dougdevine]

I can make Excel sing with the best of them and I have never heard of DGET. Well done, mate!

[johnq]

Great info! Spent years grinding Index/Match lookups and never ever heard of DGET. Now I have to watch all of your other vids to see what else I've been missing.

[abrotherinchrist]

Bravo. Thanks for showing me something new! I've been using Excel for years and never heard of DGET.

[hpottstock]

Mate, I wish I'd seen this video a few days ago. I ended up using CHOOSE inside a VLOOKUP inside an IF statement (!!) This is brilliantly straightforward. Thank you so much!

[theone]

I 2nd Dougdevine27's comment. I am a heavy and fairly advanced user and done things with excel where people said things like, "i didn't know you could do that in excel" but I had never heard of this function. Great job!!! 👍

[LuisMoranSV]

I've been working with Excel for almost 8 years now and never heard of DGET() before, this will definitely make life easier... Thank you so much!

[ahmedal-dossary]

I was aware dget can replace vlookup and other functions. However, its ability to handle and replace array formulas is certainly something we should appreciate..!!!

Thanks for sharing.

[dolittlediehard]

🎉 Very good! I was vaguely aware of this formula but haven't used it. Until now!

[siddharthg]

Never heard about such a super formula, thanks for sharing

[rousebithol]

Thank for deeply explaining with good example. If possible, please add more relevant group of D* such as Dget, Dsum, Dmin, and Dmax. Thank again for kind sharing knowledge.

[TruthofDilly]

Like your style man, very cool and to the point, no faffin, 🙏🏽thanks

[Stepford]

Great. Thanks for sharing. Whilst I can see the many advantages of DGET, the biggest disadvantage as far as I can see (unless I am missing something) is that you can't copy the formula down

[barking_mad]

You do realise I've got to rewrite all my spreadsheets now! Really useful stuff!

[karenbourke]

Love Excel. Thanks for this. I didn't know about DGET

[sachinrv]

It's fantastic. This function is a combination of some features of vlookup and advanced filter. thanks for sharing

[jdupes]

Nice. Much easier alternative to array formulas.

[Robert]

Very cool. You taught this old dog a new trick.

[wayneedmondson]

Hi Alan.. thanks for the clear and concise intro to DGET(). It is a new one for me and after watching your video, I can already think of ways to use it in my work.. excellent. Thumbs up!

[enrikekasijas]

Never heard of this function. It's amazing;)