DGET
Syntax:
DGET ( database , field , criteria )
Description: Extracts a single value from a column of a list that matches the specified criteria. (See the DAVERAGE function §3.17.7.77.)
Arguments:
Name |
Type |
Description |
|---|---|---|
database |
reference |
The range of cells that makes up the list or database. |
field |
text, number |
The column to which criteria shall be applied. |
criteria |
reference |
The range of cells that contains the specified conditions. |
For a detailed description of each argument, see the DAVERAGE function §3.17.7.77.
Return Type and Value: number – The value of the cell that corresponds to the specified criteria.
However, if
No record matches the criteria,
#VALUE!is returned.More than one record matches the criteria,
#NUM!is returned.
example: