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!
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.
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
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!!!
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!!!
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.
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.
Thank you so much. I am new to Google sheet. your video is really hepful. and I need your tips on the issue that I have right now. Is there any similar funtion in G.Sheet. just like fiilling empty cells with value above/below in Excel, something like Editing > find select > go to special -> blanks -> emptys > Ctrl + enter.
I'm having issue with DGET and VLOOKUP when the item being looked up is very similar. For example I am looking up a column where names are B9, B12, B15, B18, etc. Both functions return no matches found.
Probably two years overdue, but yes, you can use IMPORTRANGE as the dataset for DGET function. It actually doesn't care how you get the dataset, any array would do. For instance, you can nest DGET on top of QUERY with IMPORTRANGE within in order to output one result based on multiple criteria in another table and error out when there are multiple matches. That won't be robust: DGET might error out before QUERY+IMPORTRANGE complete their task, but it's possible, and in some situations might work. However, keep in mind this is very costly in terms of performance. If you have the need to fill a lot of data, and especially when that happens on multiple sheets, I'd suggest making a receiving sheet for that and refer to it instead of using IMPORTRANGE directly, because each sheet imports ranges independently from the other.
I watch & apply dget formula for multiple times bt nt working , I don't understand about choosing FIELD in this function it's from database in ur video bt if header is same ex. In database choose field Date, & want to apply this formula in 2nd workbook in column name Date , so is it possible , I try bt nt working
Good info. So does dget work with a different google sheet address. My sheet is not in the same address as the other sheets. How would this work? Can you make a video if it's possible?
I tried this formula on a table with Dates in header. Value error occurred, if I set field to any column where header is Date. This works fine if the header is text. I tried converting Date into plain number as well. Is there any work around to this done. It's important. Will appreciate your help.
@@ExcelGoogleSheets Thanks for replying. So their is this table. Schedule of employees. Emp ID in rows and Dates in column. I'm trying to find a schedule of employee from the matching column(Date). I have a Date reference in A1 which is my look up value. Basically a dynamic Vlookup or Dget for Non text column header.
I was using the dget function on stock codes I have. Now if there is no match it hits me with the " #value! ". Is there a way in that function to say if function = value then make it say "0"
Greetings! I tried your format: =DGET($G$13:$J$22,"INVENTORY",("MATERIAL";M6)) and I get a message saying a problem with this formula. I am using 2016 version.
@@ExcelGoogleSheets only in default cases right? Even when looking for multiple criteria/vlookuping to the left through arrays VLOOKUP would be faster?
Depends on data. The reason VLOOKUP is likely to be faster is because it will search until it finds the first match and it will stop. DGET will always search the whole dataset.
Nice! I was looking for a way to handle the error returns, either finding one or not finding any. Since there are only two types of error, I used this code here: do you have any better suggestions? =if(isblank(B12);"";iferror(dget(Dados202206!A:B;2;B11:B12);if(error.type(dget(Dados202206!B:B;1;B11:B12))=6;"há +de1";"nenhum")))
Thank you so much for these videos! Very educational and your practical examples are so helpful.
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!
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!
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.
You might want to check this one out as well th-cam.com/video/kt8nUzyKj-A/w-d-xo.html
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
Fantastic!
Thank you for all of your great content
You dont even know how much this helped. Lol It was the missing puzzle. Thank you.
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!!!
Yea, it can be useful in certain cases.
You’re a good guy. Thanks
Woo-hoo! DGET rulez, and you rock! As always, useful stuff, delivered brilliantly. Thanks a lot for your work!
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!!!
Thanks for the videos they are very handy and bite size
Excellent tutorial.
Thank You1
Cool video, good alternative to Vlookup.
DGET is more powerful than vlookup, thanks to explain this through this video.
The Db function look very helpful.
Very useful function Thanks allot
Hi, thanks for the valuable video & it will be more beneficial if you give us chance to download the excel sheet you used.
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?
YOU ARE A GOD! Thank you
thanks, this helped me
Amazing tutorial it didn't take me long to fully grasp the utility of this function
Hi!
Please let me know how to use Arrayformula with DGET for auto populate
Thanks a lot!
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.
Thanks! Is there a reason why XLOOKUP is not covered in this comparison?
Afternoon, how could the formula where you specify the lookup column name and cell it's looking up be adapted for Excel?
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.
is underscore ande space do the same thing in naming the collumn?
Can this functions doing via google form? Maybe using dropdown list for criteria and to write or update certatin cell or cells ?
Very nice 💯
What if you have duplicates of your key field, what function would work?
Thanks
FILTER
hey, thank you for the video.
the range criteria is handy for multiple OR criteria, however, i could not figure out a way to do multiple AND criteria.
Arrays like this should give you and {"Stock_Number","Size";"4953-66-590",9}
Thank you so much. I am new to Google sheet. your video is really hepful. and I need your tips on the issue that I have right now. Is there any similar funtion in G.Sheet. just like fiilling empty cells with value above/below in Excel, something like Editing > find select > go to special -> blanks -> emptys > Ctrl + enter.
Search & Replace?
@@ExcelGoogleSheets somthing like this, multiple empty cells : www.ablebits.com/office-addins-blog/2014/05/02/fill-blanks-excel/
sir
google sheet main agar 1 cell k andar multiply line data ho to us ko justify kesy karin
Good job !!!!
Hi Thank you, can you give me a fix on the "more than one match error". Appreciate your reply
Does this work in an arrayformula()?
Not the way you would expect.
I'm having issue with DGET and VLOOKUP when the item being looked up is very similar. For example I am looking up a column where names are B9, B12, B15, B18, etc. Both functions return no matches found.
do dget can be used from the another sheet if yes please let me know it will be helpful
Probably two years overdue, but yes, you can use IMPORTRANGE as the dataset for DGET function.
It actually doesn't care how you get the dataset, any array would do. For instance, you can nest DGET on top of QUERY with IMPORTRANGE within in order to output one result based on multiple criteria in another table and error out when there are multiple matches. That won't be robust: DGET might error out before QUERY+IMPORTRANGE complete their task, but it's possible, and in some situations might work.
However, keep in mind this is very costly in terms of performance. If you have the need to fill a lot of data, and especially when that happens on multiple sheets, I'd suggest making a receiving sheet for that and refer to it instead of using IMPORTRANGE directly, because each sheet imports ranges independently from the other.
Great video - from a resource utilization perspective, what is faster? DGET, VLOOKUP, or INDEX/MATCH on a google sheet with 99 columns and 90k rows?
VLOOKUP or INDEX/MATCH are likely to be faster, since they only look for the first match.
I watch & apply dget formula for multiple times bt nt working , I don't understand about choosing FIELD in this function it's from database in ur video bt if header is same ex. In database choose field Date, & want to apply this formula in 2nd workbook in column name Date , so is it possible , I try bt nt working
Can you please make a video on how to create a sales report using single invoice template but creating different bills from it. Please!
Hi there! Can a Google sheet link to data from a separate Google sheet like Excel can? Thanks for you videos.
watch IMPORTRANGE function videos
Thank you! I’ll check it out.
Good info. So does dget work with a different google sheet address. My sheet is not in the same address as the other sheets. How would this work? Can you make a video if it's possible?
You can add to this formula "importrange" so that the range of information can get it from another sheet :)
@@karlaavalos2362 Awesome... It works. 👍 Thx Karla.
how do you use dget with arrayfomula?
I tried this formula on a table with Dates in header. Value error occurred, if I set field to any column where header is Date. This works fine if the header is text. I tried converting Date into plain number as well. Is there any work around to this done. It's important. Will appreciate your help.
Headers should be text.
@@ExcelGoogleSheets Thanks for replying. So their is this table. Schedule of employees. Emp ID in rows and Dates in column. I'm trying to find a schedule of employee from the matching column(Date). I have a Date reference in A1 which is my look up value. Basically a dynamic Vlookup or Dget for Non text column header.
I was using the dget function on stock codes I have. Now if there is no match it hits me with the " #value! ". Is there a way in that function to say if function = value then make it say "0"
Use IFERROR function with it.
Thank you so much
Hi sir please let me know how to apply date and time entire colum with the current date please make a video this on priority..
Can I contact you privately and get the consultation on my issue?
DGET support ArrayFormula?
Depends. If you want to return an array of matches based on array of lookup values then no. Otherwise yes.
This is great. But I'm getting #NUM errors because my id "R2" is matching anything that begins with R2... like R21, R22, R23, R200 etc Any thoughts?
SOLVED! "="& in front of the criteria forces exact match for those interested... {$I$4;"="&G6}
Correct, more here on this topic th-cam.com/video/dc64HO6ltvM/w-d-xo.html
Wonderful trick! but is this work on excel sheet?
The function exists in Excel, but it won't work the same way.
@@ExcelGoogleSheets is there ant solution, can you please help in this
@@basavarajb6994 th-cam.com/video/Z_OQr8U7RE0/w-d-xo.html
Greetings! I tried your format: =DGET($G$13:$J$22,"INVENTORY",("MATERIAL";M6)) and I get a message saying a problem with this formula. I am using 2016 version.
=DGET($G$13:$J$22,"INVENTORY",{"MATERIAL";M6})
Please add download link to sheets.
There are too many formular. So when I want to do someting new, I don't really know what do I need. 555
Which is more fast (or consumes less processing power) DGET or VLOOKUP ?
Probably VLOOKUP.
@@ExcelGoogleSheets only in default cases right? Even when looking for multiple criteria/vlookuping to the left through arrays VLOOKUP would be faster?
Depends on data. The reason VLOOKUP is likely to be faster is because it will search until it finds the first match and it will stop. DGET will always search the whole dataset.
@@ExcelGoogleSheets Got it, Thank you!
Pretty Slick!
Criteria{"EmployeeID";M6} didn't work
does EmployeeID have the same format? check that there are no spaces in the name of the column the same goes to the format and spaces of M6
🙏🏻
How to use dget in corporate desktops.
Thank Google developers foro desarrollar my Spíritus de abastecimiento internacional marketing
Perez Jeffrey Hall Richard Martin Angela
Nice! I was looking for a way to handle the error returns, either finding one or not finding any. Since there are only two types of error, I used this code here: do you have any better suggestions?
=if(isblank(B12);"";iferror(dget(Dados202206!A:B;2;B11:B12);if(error.type(dget(Dados202206!B:B;1;B11:B12))=6;"há +de1";"nenhum")))
thank you so much