Description Uses specified criteria to select a single record from a database, then displays the data found in a specified field of the selected record.
Note This is a database function, which has specific requirements that are different from most functions. For information and expanded argument descriptions, see "Database Functions".
Syntax DGET ( database, field, criteria)
Argument | Description |
---|---|
database | A reference to a range containing data that the function searches. |
field | The column within database that contains the data you want to display. |
criteria | A reference to a range containing search criteria. |
Remarks If the function finds 0 records that match the criteria, it will display the #VALUE! error. If the function finds more than one record that match the criteria, it will display the #NUM! error.
Examples This example uses the example database shown in "Database Functions" and the criteria range below.
This function returns 18940:
DGET(A1:D8,"Commissions 96",E1:E2)
See Also DAVERAGE, DCOUNT, DCOUNTA, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP