DGET - Powerful VLOOKUP, INDEX-MATCH Replacement - Google Sheets Tutorial

Learn how to match data, join data from different tables & worksheets using DGET function in Google Sheets. Learn differences between DGET, VLOOKUP, INDEX/MATCH and why DGET might be an interesting or sometimes better alternative to VLOOKUP & INDEX/MATCH.

Functions used: DGET, VLOOKUP, ERROR.TYPE, IFERROR, IF

#VLOOKUP #DGET

[elizabethmoscoso]

Thank you so much for these videos! Very educational and your practical examples are so helpful.

[dannyyeoh]

Thank you very much for this tutorial video. I have since replaced the Vlookup function with DGet. DGet is far more flexible than Vlookup where it can look both right and left of the column records and easier to understand. It is as powerful as Vlookup. Thanks again for doing this tutorial video.

[juliamt]

Another GREAT tutorial! The way you explain the whys and hows really makes it so simple and easy do understand. Well done and thank you!

[HarleyBlack]

Yeah, My first comment as well. Why? Because this was the best tutorial I have watched. others get the job done but leave some to be desired. You made it crystal clear for those with a working knowledge of spreadsheets. Thank you very much!

[mosintyagi]

Thanks Man for the great videos. I learned many things from your video's. My corporate life has been completely changed. I got appreciation letter and many things regarding my work only because of you. Thanks again

[felipe]

That errotype formula opened a possibility to me to create a panel where I can display which sheets are pending to refresh some importrange, with just a glance! Very nice!!!

[cristianllamassimon]

Great, thanks to your video I learned how to find DMin and DMax for many items in a list by using the array in the criteria part of the function. Thank you!!!

[g.muthukumar]

DGET is more powerful than vlookup, thanks to explain this through this video.

[urntindanger]

Not defending vlookup as i find database functions really useful but you can also create an array for the range you’re looking for in vlookup which would allow you to search for value on the left hand side.

[whitehoof]

Woo-hoo! DGET rulez, and you rock! As always, useful stuff, delivered brilliantly. Thanks a lot for your work!

[rabdu]

Hi, thanks for the valuable video & it will be more beneficial if you give us chance to download the excel sheet you used.

[josephlees]

You dont even know how much this helped. Lol It was the missing puzzle. Thank you.

[queenkai]

Thank you for all of your great content

[GajananFunde]

Hi, Thanks for this tutorial. What if I want to look up a value from two datasets that have similar fields with the same criteria?

[vladvovchuk]

Very nice 💯
What if you have duplicates of your key field, what function would work?
Thanks

[HisGraceOnly]

Hi!
Please let me know how to use Arrayformula with DGET for auto populate

[SorrowChant]

Thank you very much for this convenient and thorough tutorial. I was wondering whether you know any way to create a hyperlink that points to the DGET result.

[peterw]

Thanks! Is there a reason why XLOOKUP is not covered in this comparison?

[annaandfabiano]

Thanks for the videos they are very handy and bite size

[AndrewKresge]

Afternoon, how could the formula where you specify the lookup column name and cell it's looking up be adapted for Excel?