DGET()
Syntax. DGET(database,field,criteria)
Definition. This function extracts a value from a column in a list or database that matches the specified conditions.
Arguments
database (required) The cell range that makes up the list or database
field (optional) Indicates which column is used in the function
criteria (required) The cell range containing the field names and the filter criteria
Note
If no record matches the criteria, the DGET() function returns the #VALUE! error. If more than one record matches the criteria, the DGET() function returns the #VALUE! error.
Background. To find a value within a database where a field matches a specific criteria, use the DGET() function.
See Also
You will find more information about search criteria in the section ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
