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;
www.computergaga.com
** Online Excel Courses **
The Ultimate Excel Course - Learn Everything ► bit.ly/UltimateExcel
Excel VBA for Beginners ► bit.ly/37XSKfZ
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2Siivkm
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1

[@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!

[@Computergaga]

Happy to help 👍

[@dougdevine27]

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

[@Computergaga]

Thanks Doug. Excel has a beautiful voice.

[@andrewlankford9634]

Probably because new versions of Excel try so hard to hide the help file from the user.

[@abrotherinchrist]

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

[@Computergaga]

You're welcome George. Thank you.

[@johnq7242]

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.

[@Computergaga]

Welcome aboard, John 👊 INDEX-MATCH is a better formula and far more flexible than DGET. But DGET is simpler for this specific instance on creating summaries for Dashboards and Reports.

[@rousebithol7519]

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.

[@wayneedmondson1065]

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!

[@Computergaga]

Thanks Wayne.

[@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!

[@dougmphilly]

seriously, that was so simple

[@eriol33]

holy cow, this is what I have been looking in excel, all this time!! thank you!

[@Computergaga]

You're welcome Eriol.

[@Saggi0405]

Awesome.. Learned something new and valuable today.. Never heard and didn't knew it was so easy.. Thanks..

[@MrTopdawg47]

Cool, never heard of DGET. Excels library is vast. Thx for sharing the knowledge.

[@Computergaga]

My pleasure Tahj.

[@sachinrv1]

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

[@Computergaga]

Thank you. You're welcome Sachin.

[@rajeshmmishra5062]

@@Computergaga .. hi it's working only for 1st row not for next

[@ardip.6930]

Great. Thank you and I cant wait to start using this formula.

[@Computergaga]

Happy to help Ardi.

[@theone1347]

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!!! 👍

[@Computergaga]

Thank you.

[@siddharthg4623]

Never heard about such a super formula, thanks for sharing

[@Computergaga]

My pleasure Siddharth.

[@alnitak1003]

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!

[@Computergaga]

My pleasure Luis.

[@karenbourke1783]

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

[@Computergaga]

Thank you Karen.

[@ahmedal-dossary4386]

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.

[@Computergaga]

My pleasure Ahmed.

[@mohideenthassim7180]

many thanks Alan, I did not know dget existed, a great tool and a great tutorial as always. Cheers Mohideen

[@Computergaga]

Thanks Mohideen.

[@georgiaserpe]

All I have to say is WOW!! Thank you.

[@Computergaga]

You are more than welcome Georgia.

[@barking_mad6649]

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

[@Computergaga]

Sorry buddy 😀

[@jbkend]

Sounds fun! 😁

[@jaipalrana.]

SUPERB!!! NEW ADDITIONAL KNOWLDGE this is really a Secret VLOOKUP alternative

[@Computergaga]

Thank you Jaipal.

[@JPAlpano]

Only works if you are only looking for one id. If you have multiple ids to lookup, you cannot drag the formula down.

[@martijnfransen9933]

nice function gonna use it monday was doing it with a long index and match formula now thanks for the tip

[@Computergaga]

Happy to help Martijn.

[@dolittlediehard1670]

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

[@Computergaga]

Thank you 😊

[@khalidrehman5045]

Wow, amazing, I never used this before but i will definitely try this. Thumbs up

[@Computergaga]

Excellent! Thank you Khalid.

[@pralhadshetye8863]

Amazing !! Never heard of this function before.

[@Computergaga]

Thank you.

[@David_F579]

Excellent video. Thank for sharing. Never heard of DGET.

[@Computergaga]

Thank you David.

[@TruthofDilly]

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

[@Computergaga]

I appreciate that. Thank you.

[@ahmad.s4723]

Love this formula, great video ✔

[@Computergaga]

Thank you.

[@panagiotistheodorou4959]

Crystal Clear Sir. Thank You

[@Computergaga]

You're welcome Panagiotis.

[@semperdiscendum7439]

Awesome! Thank you!👍👍

[@Computergaga]

You're welcome. Thank you Shashikant.

[@donlanky6388]

Wow!!!!!!!!! I never knew this. Fab work sir. Thanks

[@Computergaga]

Thank you Mike.

[@mishraamukesh]

Exceptional... Thank you

[@Computergaga]

You're welcome Mukesh. Thank you.

[@huseinc]

Thanks for sharing this valuable information

[@Computergaga]

You're very welcome.

[@enrikekasijas705]

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

[@Computergaga]

👍

[@eunicesiu6249]

This is better than using Vlookup! Thanks for posting the tutorial!

[@Computergaga]

You're very welcome.

[@mariadiokno1220]

Very helpful. thanks.

[@Computergaga]

No problem Maria.

[@ashishtrivedi8253]

Fantastic job sir! Thanks. 👍

[@Computergaga]

You're welcome Ashish. Thank you.

[@papnyanamah2748]

You’re amazing. Plus 1 subscriber 💪💪💪

[@Computergaga]

Thank you Pap.

[@Everyonelovesyou]

Nice sharing...… I did not knew about this secret function of excel

[@Computergaga]

Excellent! You're welcome.

[@miroslavtriebel8126]

Definetely thumb up for this video sir!

[@Computergaga]

Thank you Miroslav.

[@RC-nn1ld]

Wow this is fantastic!

[@Computergaga]

Thank you Roger.

[@tofiq045]

Great tricks , thanks

[@Computergaga]

Thank you.

[@pianothatilove]

Absolutely brilliant

[@Computergaga]

Thank you 😊

[@Econotrix]

very useful video. great 👌👍

[@Computergaga]

Thank you 😊

[@oliviermanbode4788]

Ver y useful....thx for sharing

[@Computergaga]

You're very welcome Oliver.

[@patriktrivedi]

It's good to know but not a replacement for vlookup. what to do when you have to apply the same in multiple rows? still worth sharing. keep it up.

[@emmadkareem5247]

The major issue is with Excel defines the "Criteria" for DGET. It should have been a simple condition.

[@kevinclifford2637]

Great thank you!

[@Computergaga]

My pleasure Kevin.

[@mavillalobos]

Very useful!!!

[@Computergaga]

Thank you.

[@k.chriscaldwell4141]

Superb! Thanks.

[@Computergaga]

You're welcome Chris.

[@WhereIsHeist]

Solved a problem I was having with Vlookup! thanks!

[@Computergaga]

Excellent

[@balag3480]

Awesome thanks for.nice presentation.

[@Computergaga]

You're welcome. Thank you Gurrappa.

[@kirandeepchoudhry9232]

Superb! Awesome

[@Computergaga]

Thank you Kirandeep.

[@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

[@Computergaga]

This is true. Was designed as a summary function rather than for lists.

[@loriperezlp]

Hi Steve, You can use "Xlookup" function for lists. This replaced "Vlookup" for me.

[@Stepford]

@@loriperezlp yes, I am aware of that Lori... when it eventually becomes widely available. I have MS Office 365 ProPlus, but it's still not available to me!

[@shanefield7339]

@@loriperezlp oh can we? *as we all sit here waiting for xlookup* :)

[@hemanthk4455]

Thanks for sharing .

[@Computergaga]

You're welcome Hemanth.

[@Robert8455]

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

[@Computergaga]

Thank you.

[@marceloribeirosimoes8959]

Thank you very much!

[@Computergaga]

My pleasure Marcelo.

[@joeeydouglas]

Very good ... Thank you

[@Computergaga]

Thank you Joeey.

[@jdupes7708]

Nice. Much easier alternative to array formulas.

[@Computergaga]

Yes, definitely

[@samsabrosa6841]

Wonderful tutorial

[@Computergaga]

Thank you Sam.

[@raja-dq1dj]

Really thank you s much sir.... Very usefull formula

[@Computergaga]

You're very welcome. Thank you.

[@computertutoring]

Thanks Alan may include this in my intermediate course 😉

[@Computergaga]

Thank you.

[@sudhirhiwale9784]

Super. Thanks

[@Computergaga]

You're welcome Sudhir.

[@entertainmentgalaxy971]

thanks for sharing....

[@Computergaga]

My pleasure.

[@Eric.Ramirez.]

Wow!!! Thanks a lot.

[@Computergaga]

You're very welcome Eric.

[@saigonbaby]

brillant. thanks

[@Computergaga]

You're welcome Theo.

[@khalidQweder]

Excellent.

[@Computergaga]

Thank you very much Khalid.

[@alxmampilly]

bloody brilliant

[@Computergaga]

Thank you Alex.

[@jonrend]

Cool man, another way of extracting data on multiple criteria

[@Computergaga]

Thanks Jon.

[@clivepetty2338]

Very good, I can see applications for this

[@Computergaga]

Thanks Clive.

[@banglatechhotspot2235]

Helpful tutorial sir

[@Computergaga]

Thank you.

[@RemofRenaissance]

Great video! Just one query - In the example 9mins in could you put other variables from row 4 onwards (under Product and Country) and would the DGET formula return the different results for sales in cells H4, H5, etc??? Many thanks for your help in advance and hope not too annoying!

[@BURRhypopo]

Since you cannot drag down the formula (e.g. if you had Produce Canada in row 5), what’s the solution to that? I also don’t want to use a helper column. Thanks

[@senachakraborty875]

I am facing problems while doing DGET. Where the data are in columns & i need to find the results in rows can you help please

[@SasiKumar-pn6zj]

After using dget function if I press Ctrl+D this function is not working for the second line item is there is any option to use dget function for n number of line items

[@subway22523]

THANKS, ITS REALLY GOOD INSTEAD OF VLOOKUP WE CAN USE THIS, BUT HOW ABOUT IF I WANT TO DRAG THE SAME FORMULA BELOW THE SAME LINE WILL BE TAKE OTHER RESULT TOO FOR "PRODUCE CANADA" DATA

[@br31woodlands69]

Wonderful

[@Computergaga]

Thank you.

[@SujathaS-sx3kg]

Thanks for clear explaination. It's really helpful. Instead of index and match, can i use dget function.

[@Computergaga]

You're welcome. It depends on the situation. This is a database function so great for summarising data, INDEX & MATCH more for retrieving data for lists.

[@yenhatesme]

Been using vlookup for a long time, always annoyed by the limitation. Thanks for the video, learned a better replacement for vlookup!

[@patriktrivedi]

dear its not like replacement. vlookup is far better then this one.

[@nitinbhosale01]

Wow.... Thank u

[@Computergaga]

You're very welcome.

[@markjosephlee5522]

you got a new subscriber :)

[@Computergaga]

Excellent. Great to have you aboard.

[@ravikrishn4637]

Excellent

[@Computergaga]

Thank you Ravi.

[@vijay2yuvi]

can you make video on the following functions together for if(indirect(concatenate(match()))

[@ItGstTaxTV]

I want to auto starting multiple different types of files move to related folder .

[@brianhogan9563]

Would the database part become dynamic if it were made into a table that can be updated?

[@kvlpnd]

Great video…

[@Computergaga]

Thanks Keval.

[@wongpeggy4363]

Hi, just to check. under this Dget function can it work in a diff workbook or worksheet? exp: I want to use the main worksheet get the info from others workbook. This Dget can it work in this way?

[@umehtoch]

Watching this video has really been an eye opener. I never hears about the DGET function and its wonderful features till now. However, the search is only on one row. What if I have data to search for on the the second or third rows, if I pull the formula down to the next row, would the formula still work?

[@Computergaga]

I'm afraid not Tochukwu. This lookup is more for your summary uses.

[@mikelennon1078]

Just to confirm would it return multiple rerecords as well? Let's say I select a company name from a drop down list or Combo Box then it returns the list of all it's employees who work there with their first name, last name, title, phone, email address,.........from another worksheet? Is there an easier way to achieve this goal?

[@sredharbalaraman1387]

Thanks buddy

[@Computergaga]

You're very welcome Sredhar. Thank you.

[@mans0011]

Thanks for the great video! In your examples you have a single line of conditions for DGET (Produce in Denmark), but what if you were making a list of things, similar to a pivot table? Could you Put Produce in Canada underneath and still construct a DGET that will skip over the first row of measures and only look up the second row?

[@Kiyoshi_9606]

I wanted to do this, too :(

[@namushede7548]

How to remove ' in column cells at start it is automatically comming

[@AllMappedOut86]

Is there another way of inputting the criteria apart from as a range? It would be ideal if you didn't have to use any cells to call the function, which is why I don't really use the advanced filter functionality either

[@kerx.1660]

If possible, I want to click "like" for 100 times!👍👍👍+++

[@Computergaga]

Thank you Stephanie.

[@_Killsammy]

It helps me so much as an excel warrior,

[@Computergaga]

Keep fighting the fight warrior

[@rashpalbhatia5747]

One word waaaaooo thanks sir

[@Computergaga]

You're welcome Rashpal.

[@yosef-yosef9414]

you deserved to be subscribed

[@Computergaga]

Thank you Yosef.

[@yosef-yosef9414]

@@Computergaga because you helped people. thank you too 👌(from the Philippines)

[@uvais]

Can we use dget if the table is in a different workbook

[@akhmet274]

great!

[@Computergaga]

Thank you Akhmet.

[@generalflights3241]

Thanks

[@Computergaga]

You're welcome.

[@msmediascreenentertainment1951]

sir very nice formula

[@Computergaga]

Thank you.