Grab the file I used in the video from here 👉 pages.xelplus.com/dget-file

Thanks Leila. Most enjoyable. Sometimes the old formulas need an introduction to a modern audience. Love to see what you can do with the "N" Formula :-)

Thanks Leila for this amazing function, will definitely use it

Very useful video, your solutions give a professional touch to each worksheet

Thanks for covering DGET. Ostensibly it works like LOOKUP function but far more easy to follow. Thanks again:)

@LeilaGharani

4 жыл бұрын

My pleasure Sachin :)

Hi Leila. Thanks for the great DGET formula examples! Good to know how this function works :)) Thumbs up!!

Thanks Leila. An oldie but a goodie.

As always a very useful and cristal clear video, many thanks ! Another option for multiple criteria is to use Xlookup with concatenate criteria and lookup on concatenate columns. It works well but request more memory to calculate the results (particularly when calculating on a big dataset)

Wow, thanks for inspiring and solving an issue I had just last week. Can't wait to get to work and implement this!

@LeilaGharani

4 жыл бұрын

Hope it will be useful.

Thank you so much @Leila, You are the best :-) Always looking forward to learning something new in excel

Great video as always. Thank you very much for your time and knowledge.

I really enjoy your excel tutorials. I am two years retired from a job where I used excel extensively, but I still enjoy writing formulas for personal spreadsheets. Thank you for sharing you excel skills.

All your videos worth watching and thumbs up. Thank you.

Clean and simple for us beginners, thank you.

Leila, thank you so much for being such an amazing teacher of Excel. If I knew just 1% of what you know as well as you know it I would know a thousand times more about Excel than I do. Thank you again and again.

I love you please never stop making videos

It's great. I was looking for such videos. Now I can solve so many problems. Thanks Leila.

Very well explained, as always! Thanks Leah . . .

This is great, You present it very nicely. Thank you!

Don't think I stop watching your videos, DGET, this function is so magical 😍

@LeilaGharani

4 жыл бұрын

Oh, there you are. I thought you had forgotten me :)

Quite informative as always, thanks! 😃👌

Thank you very much Leila for showing this forgotten function, it is very useful and compatible with old versions of Excel :)

@LeilaGharani

4 жыл бұрын

My pleasure. Glad it's useful.

Thank you for the tutorial. Very informative.

Very good tutorial as always! :)

Hi Leila! I like your excel videos ....alot.. I have learnt many things because of you... thanks alot

Just what I was looking for, thanks

We've been waiting for this. But still a fan of Index-Match. 😁

@LeilaGharani

4 жыл бұрын

Both have their place :)

@stevengodoga2648

4 жыл бұрын

Same here

@ScottStratton

4 жыл бұрын

Ditto, but this was way cool

@arindambhattacharya7848

3 жыл бұрын

True. Didn't even find a case to use this with justice nor does this seems to offer any

@Rice0987

3 жыл бұрын

I'm using & for complex criteria.

Wonderful as always. thanks

you had long time to publish this video I appreciate that. Thanks that was wonderful mum.. Respect

@LeilaGharani

4 жыл бұрын

Glad you like it.

Thanks. Following your videos and I am learning so much.

شكراً! !This looks like it could be a bit easier for me to use than index/match in some situations! Thanks again

This is the first time i know about this function, thankss 😊

Thanks again. You are wonderful. Great job.

You are an amazing teacher

Thanks for given your contribution

@Leila I see you bring an old, weel-worn excel to life = good job, merci :)

@LeilaGharani

4 жыл бұрын

Gotta respect the Goldies :)

Great video, thanks!

best teacher..............and teaching style

Great. I have decided not to miss your new video tutorial....because it's of great help in my daily routine/work. Many thanks Ms. Leila G.

@LeilaGharani

4 жыл бұрын

Very good decision :) Glad the tutorials are helpful.

Awesome video... Easy to understand.

Awesome, i always google when it comes to Excel formulas :D

Good stuff. Really like your channel!

Thank you. For all your support You are the best woman in the world.

Thank you so much for such amazing video 😊

Thank you for this video Leila.

going old school! Thanks for the DGET example :-)

@LeilaGharani

4 жыл бұрын

Totally! Bringing out the classics :)

I don't know about this formula. Thank u so much for increasing my knowledge

Thanks, nice concept

Learning a lot from your tutorials. Easy to understand...Way to go...

@LeilaGharani

4 жыл бұрын

That's great. Thanks for the feedback.

Excellent explanation.

Thx Leila. Very clear. I see the #num as both a con as you say and a also as a pro, as getting the first occurrence of duplicates not knowing there are others can lead to errors in interpretation and decisions.

I love all ur videos

Nice addition for the index and match combo funtion is that match() works for multiple matche per row too. You could youse the multiple matches like (A1="x")*(B1="x") etc. Excel could take up some long processing time with large tables though. Mine took around 30 to 40 minutes for a table with 7000 rows and 3 matches acros.

Genius! Hands down genius.

I salute your teaching skill...

Great and very useful information...thanks for knowledge sharing....

Very useful tool...Thanks

Great video! Thanks a lot! it was usefull!

Woo amazing... thank you so much Mam....

This is great function! Thanks for showing it to us Leila! I will no longer need to count columns for Vlookup in my files with 200 columns! I use Index-Match often to avoid it, and Dget seems to be even more elegant solution for many situations.

@TheTuTuTurtle

3 жыл бұрын

problem is you can only lookup 1 row with DGET, so you will still have to use index match

@AtanasNenov

2 жыл бұрын

You don't need to count columns for vlookup. It shows the current column count in the tooltip at the lower right part of your selection.

Great explanantion! Nice laptop by the way (for a Office user geek xD)

@LeilaGharani

4 жыл бұрын

Haha. Gamer laptops are great for video editing too :)

Really Nice look..and nice teaching .

Thank you Leila!

Good knowledge for me!

Yours technique way is simple and easy. User friendly.

Leila, I appreciate your informative videos, but I am having limited success using DGET() to fetch a single value within a table based on two values in the same table from another sheet. Essentially, only the first one works because the heading is on row 1 and the criteria is on row 2, but when I try to "knit" together a range that assembles the heading on row 1 with the values on row 3, it fails to fetch the value from the other sheet. Any thoughts on that one? Thanks!

Brilliant. I never knew that.

Because of you today i able to learn new funcation which i dont know before thanks

Awesome function

Great Video Leila. Very Interesting. :) :)

Marvelous work madam...

You teach so good Thank you so much from Tehran

You are a great professor Leila I love your channel!.Thank you for the excellent tip.^_^

@LeilaGharani

4 жыл бұрын

Thank you! 😃

Ur really great... Iam 13 yrs working has wfm... I never came across such a easy and important formula

Thank you very much, Leila! I congratulate you for your high quality in the transmission of knowledge. By the way, I've tried DGET with Tables, and found to my amazement and sadness that it doesn't work.

you are the best, big up

Fantastic..thq

Really great 😍😍😍

That's a wonderful function, but I feel, LOOKUP is still a better alternative. You always ROCK Leila :)

Awesome. No more working with array formulas. Thanks

Thanks Leila :)

I wonder if we can create a "Four-way logarithmic graph" in excel (the 2 vertical and horizontal axis plus 2 extra diagonal axis). I might be asking too much

@ivanxdxd

4 жыл бұрын

Nah

Thank you for the great function. just to make something right. I have tried using the function with a table instead of range selection and it is not working. the reason that I figured out is that typing the table name makes it selected without the headers. in order to use it as a full table, you need to refer it as =DGET(Table1[#All],1,J4:J5)

Thanks for sharing

nice information this thank you very much ,,,,,,

Great video. So other than xlookup, what do we use for drill down for multiple conditions?

Very useful...

Good explanation

Very useful formula

Awesome video. Thank you

I like Dget function, it is very handy. Vielen Dank Liebe Leila, Viele Liebe Grüsse 🤗

@LeilaGharani

4 жыл бұрын

It does have its benefits. Glad you like Katerina :)

Nice lesson!

@LeilaGharani

4 жыл бұрын

Thanks! 😃

Love from Pakistan.. doing great.

Thank you

Thank you.

Hi, I just want to know if we have the same name and they are working in different departments than this function could help us to get the exact value.

Thanks dear

I was in a rush and last time i did this i did a 6 way repeating if statement. Thanks for sharing its much simpler this way than that and INDEX matching :D

@LeilaGharani

4 жыл бұрын

Glad it's helpful. DGET definitely has its advantages in certain situations.

Your teaching of excel is really lovely and impacting. Please I want you to produce a video that will teach how to prepare school time table that will be high flexible. With the following features: 1. A teacher possibly taking more than 1 subject. 2. A class possibly having 2 subjects at the same periods. 3. Each subject having its own no of periods per week. 4. Possibility of science subjects in science laboratory, with consideration that two/three classes may be sharing the same laboratory. And other possible features. I will appreciate it if you can work on it. Thanks.

Thank you very much 😍😍😘😘