<< Click to Display Table of Contents >> DGET (database function)

Syntax:

DGET(DatabaseArea, Column, CriteriaArea)

Description:

Returns the value in a column of a database area that matches the given criteria.

For more information on the use of database related functions, see Working with database functions.

DatabaseArea is a cell range containing the database to be evaluated. The first row of DatabaseArea must contain labels for the database columns (e.g., Amount, Price, etc.).

Column is the desired column of the database area. You can specify Column by its relative column number or by its column label in double quotation marks (e.g., "Amount", "Price", etc.).

CriteriaArea is a cell range containing one or more conditions that have to be fulfilled. The first row of CriteriaArea has to contain column labels (e.g., Amount, Price, etc.).

Note:

If more than one value matches the specified criteria, the function returns a #NUM! error value.