81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



Returns a single value from a database table-like array or range using a SQL-like query.

How To Use in Sheets

DGET(database, field, criteria)

External Links

DGET - Powerful VLOOKUP, INDEX-MATCH Replacement - Google Sheets Tutorial

Learn how to match data, join data from different tables & worksheets using DGET function in Google Sheets. Learn differences between DGET, VLOOKUP, INDEX/MATCH and why DGET might be an interesting or sometimes better alternative to VLOOKUP & INDEX/MATCH. Functions used: DGET, VLOOKUP, ERROR.TYPE, IFERROR, IF

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.