Join 400,000+ professionals in our courses here https://link.xelplus.com/ytdallcou...
It's time to explore an underutilized yet powerful formula: the DGET function. Perfect for solving complex LOOKUP problems that VLOOKUP can't handle, DGET allows for searching based on multiple conditions and looking up values to the left of the LOOKUP range.
⬇ DOWNLOAD the workbook here: https://pages.xelplus.com/dgetfile
✨ Key Highlights:
▪ Solving Multiple Condition Lookups: Learn how DGET overcomes VLOOKUP limitations by enabling searches based on multiple criteria.
▪ Left Lookups: Discover how to use DGET for retrieving values to the left of the LOOKUP range, a task challenging for traditional LOOKUP functions.
▪ Practical Examples: Follow realworld scenarios to understand how to implement DGET in various situations, like finding division and department names based on specific criteria.
▪ Dynamic and Flexible Filtering: See how DGET can dynamically filter data and adapt to approximate matches for versatile data analysis.
▪ Understanding Limitations: Get to know the potential drawbacks of DGET, such as handling duplicates and limitations in applying the formula to multiple cells.
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.
00:00 Excel DGET Function
01:44 Excel DGET Explained
06:03 DGET With Approximate Match
06:28 DGET With OR & AND Conditions
08:18 DGET With Multiple Criteria
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).
Related Videos
Excel Index Match basics: • How to use Excel Index Match (the rig...
Excel VLOOKUP explained: • VLOOKUP EXPLAINED 2 Practical Excel...
Excel XLOOKUP: • How to Use the NEW & IMPROVED Excel X...
Excel FILTER function: • Excel FILTER Function Lookup to Ret...
Check out the complete Excel Lookup Formula Playlist: • Excel Lookup Formulas
➡ Join this channel to get access to perks: / @leilagharani
☕ Get the Official XelPlus MERCH: https://xelplus.creatorspring.com/
Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/coursequiz/
RESOURCES I recommend: https://www.xelplus.com/resources/
Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
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!
#excel