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:

------ Related Videos -------
Excel Index Match basics:
Excel VLOOKUP explained:
Excel XLOOKUP:
Excel FILTER function:
Check out the complete Excel Lookup Formula Playlist:


★ My Online Excel Courses ►

✉ Subscribe & get my TOP 10 Excel formulas e-book for free


EXCEL RESOURCES I Recommend:

Get Office 365:
Microsoft Surface:

GEAR
Camera:
Screen recorder:
Microphone:
Lights:

More resources on my Amazon page:

Let’s connect on social:
Instagram:
Twitter:
LinkedIn:

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

XelplusVis,Leila Gharani,Advanced Excel tricks,Excel online course,Excel tips and tricks,Excel for analysts,Microsoft Excel tutorials,Microsoft Excel,Excel 2016,Excel 2013,Excel 2019,XelPlus,Excel DGET function,Excel database functions,Excel Dget as vlookup,Excel dget lookup,excel approximate match lookup,excel Dget Or condition,Excel Dget multiple criteria,Excel Lookup multiple criteria,Excel left lookup,Dget returns error,Dget #Num,