DGET function in micro soft excel sheet
Summary
In the Excel DGET, the function gets a single value in a given field from a record that matches the criteria. DGET will throw the #NUM error if more than one record matches the criteria.
Purpose
Get value from matching record
Return value
The value in a given field
Syntax
1: Database.
2: Field.
3: Criteria.
=DGET (database,
field, criteria)
=DGET(B4:F40,3,C2:C3)
Arguments
Database: Database range including headers.Field: Field name or index to count which column number.
Criteria: Criteria range including headers.
