Returns a single value from a database table-like array or range using a SQL-like query.
Description
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 yet. Stay tuned!