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: Using the data in the example in the DAVERAGE function §3.17.7.77:

For all the apple trees having a height between 10 and 16, the number of Profit fields that are not blank is computed by DGET(A4:E7,"Yield",A1:A2), which results in 14.

end example]