Excel DGET Function Solves 2 of Your VLOOKUP Problems
Excel DGET Function is one of Excel's "forgotten" database functions that can do a Left lookup (unlike VLOOKUP) and ALSO easily look for multiple criteria.
One limitation of DGET is that you can't apply it to multiple cells. Basically you can't pull down the formula to lookup different values. If that's something you need, then you'll need to use INDEX MATCH, VLOOKUP, Excel FILTER function or FILTER feature or XLOOKUP. Check out the links under Related Videos below to find these videos.
Excel DGET advantages:
1. DGET is an easy formula - Excel DGET expalined (1:44)
2. DGET can look for approximate matches (6:03)
3. DGET can look for OR conditions - If either condition is met (6:28)
4. DGET can match multiple criteria (8:18)
5. DGET can lookup values to the left
6. DGET acts like an automatic filter
Excel DGET disadvantages:
1. DGET formula can't be pulled down - you'll need to include the header for each lookup value
2. DGET returns an error (#Num error - 7:25) if there are duplicate lookup values in the range (as opposed to VLOOKUP or Index & Match which return the first match).
⯆ DOWNLOAD the workbook at the bottom of the blog post here: https://www.xelplus.com/excel-dget-function
------ Related Videos -------
Excel Index Match basics: https://youtu.be/F264FpBDX28
Excel VLOOKUP explained: https://youtu.be/hwL6KKJP-_I
Excel XLOOKUP: https://youtu.be/4c0CLUER6nw
Excel FILTER function: https://youtu.be/Eehk6PC0oGs
Check out the complete Excel Lookup Formula Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyxpMnh_KKfAgp5DF9ydawmi
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
Видео Excel DGET Function Solves 2 of Your VLOOKUP Problems канала Leila Gharani
One limitation of DGET is that you can't apply it to multiple cells. Basically you can't pull down the formula to lookup different values. If that's something you need, then you'll need to use INDEX MATCH, VLOOKUP, Excel FILTER function or FILTER feature or XLOOKUP. Check out the links under Related Videos below to find these videos.
Excel DGET advantages:
1. DGET is an easy formula - Excel DGET expalined (1:44)
2. DGET can look for approximate matches (6:03)
3. DGET can look for OR conditions - If either condition is met (6:28)
4. DGET can match multiple criteria (8:18)
5. DGET can lookup values to the left
6. DGET acts like an automatic filter
Excel DGET disadvantages:
1. DGET formula can't be pulled down - you'll need to include the header for each lookup value
2. DGET returns an error (#Num error - 7:25) if there are duplicate lookup values in the range (as opposed to VLOOKUP or Index & Match which return the first match).
⯆ DOWNLOAD the workbook at the bottom of the blog post here: https://www.xelplus.com/excel-dget-function
------ Related Videos -------
Excel Index Match basics: https://youtu.be/F264FpBDX28
Excel VLOOKUP explained: https://youtu.be/hwL6KKJP-_I
Excel XLOOKUP: https://youtu.be/4c0CLUER6nw
Excel FILTER function: https://youtu.be/Eehk6PC0oGs
Check out the complete Excel Lookup Formula Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyxpMnh_KKfAgp5DF9ydawmi
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
Видео Excel DGET Function Solves 2 of Your VLOOKUP Problems канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
How to use Excel Index Match (the right way)Top 25 Excel 2016 Tips and TricksBuild Impressive Charts: It's NOT your usual Bar Chart (Infographics in Excel)INDEX MATCH Explained (An Alternative to VLOOKUP)Uncover Windows 10 Most Useful Features TodayThis Excel Chart will grab your attention (Infographic template included)4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 110 Super Neat Ways to Clean Data in ExcelHow to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)Discover What XLOOKUP Can Do For YOU (R.I.P. Excel VLOOKUP)SURPRISING Advanced Filter TRICK in Excel (You've Never Heard Of!)Return Multiple Match Results in Excel (2 methods)Progress Circle Chart in Excel as NEVER seen before!Excel 3D Formulas Explained (Includes a Bonus Excel Hack!)Easily Import Data from Web to Excel (2 Practical Examples)Excel shortcut keys you SHOULD know!SUPER EASY Excel Data Entry Form (NO VBA)Excel Lookup to Return Multiple Values with FILTER FunctionYour Excel Printing Problems, Solved!