returns the contents of a cell in a column of a database table, in the unique row meeting the criteria.
DGET(database_table; field; criteria_table)
- database_table is a range defining the data to be processed.
- field is the column containing the cell. field may be a column number (1 is the first column of the database table, 2 is the second ...) or a column header (enclosed in quotation marks "") or a cell referring to a column header.
- criteria_table is a range containing criteria, which are used to select the unique row of the database_table.
- The Database functions overview fully describes the use of these parameters.
DGET returns #VALUE! if no row is found, and Err502 if more than one row is found.
In this spreadsheet: