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.