Returns a single value from a database table-like array or range using a SQL-like query.
81% OFF online library of tutorials for mastering Google Sheets
81% OFF online library of tutorials for mastering Google Sheets
One time purchase $199
Description
How To Use in Sheets
DGET(database, field, criteria)
External Links
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.