438 views
In this video, we review the DGET function, which is a distinct function from the lookup functions, where we review the basics of the DGET function, and we also review how to use it in different cases such as searching with any of several conditions and searching with multiple conditions Download the example file: http://tinyurl.com/y8nhe2b6 Playlist of other lookup functions VLOOKUP, XLOOKUP, INDEX + MATCH: • Lookup Functions - Lookup Functions My channel in English: @excelbonanza For communication and consultations: [email protected] Follow us on social media Facebook: https://tinyurl.com/yj97rzyd Twitter: https://tinyurl.com/y752pbkb Youtube: https://tinyurl.com/yzure843 Instagram: https://tinyurl.com/mry2bpcr Linkedin: https://tinyurl.com/3utep6r7 Telegram channel: https://tinyurl.com/yj5a3u7c TikTok: https://tinyurl.com/bd8u7edt Join our Facebook Group: https://bit.ly/2W0txvg Support on Patreon https://bit.ly/2BRZbCT Watch the playlists on the channel: Excel VBA - Programming with Excel: • Excel VBA - Excel VBA - Explanation of VBA Excel... Excel Power Pivot - Power Pivot: • Power Pivot & DAX Power Pivot and DAX Miscellaneous functions: • Miscellaneous functions Lookup functions: • Lookup Functions - Lookup functions Date and Time functions - Date and Time in Excel - Time and date... 00:00 Introduction 00:38 How to use the DGET function 04:21 Advantages and disadvantages of the DGET function 07:01 Searching with any of several conditions using DGET 08:59 Searching with multiple conditions using DGET 10:37 Conclusion + Excel course from the beginning to professionalism #Excel #Excel #Search_functions #Learn_Excel #Learn_Excel