Documentation/How Tos/Calc: DGET function

From OpenOffice.org Wiki

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:

Database functions overview

DCOUNT function, DCOUNTA function, DSUM function, DPRODUCT function,

DMAX function, DMIN function, DAVERAGE function,

DSTDEV function, DSTDEVP function, DVAR function, DVARP function,

SUM function, SUMIF function, SUBTOTAL function

Conditional Counting and Summation