DGET function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
DGET
returns the contents of a cell in a column of a database table, in the unique row meeting the criteria.
Syntax:
DGET(database_table; field; criteria_table)
where
- 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.
Example:
In this spreadsheet:
| A | B | C | D | E | |
| 1 | Name | Grade | Age | Distance to School | Weight |
| 2 | Andy | 3 | 9 | 150 | 40 |
| 3 | Betty | 4 | 10 | 1000 | 42 |
| 4 | Charles | 3 | 10 | 300 | 51 |
| 5 | Daniel | 5 | 11 | 1200 | 48 |
| 6 | Eva | 2 | 8 | 650 | 33 |
| 7 | Frank | 2 | 7 | 300 | 42 |
| 8 | Greta | 1 | 7 | 200 | 36 |
| 9 | Harry | 3 | 9 | 1200 | 44 |
| 10 | Irene | 2 | 8 | 1000 | 42 |
| 11 | |||||
| 12 | |||||
| 13 | Name | Grade | Age | Distance to School | Weight |
| 14 | Frank |
DGET(A1:E10; "Age"; A13:E14)
- returns Frank's age (7).
DGET(A1:E10; C1; A13:E14)
- also returns Frank's age (7).
See Also
