DGET
Extracts from a database a single record that matches the specified criteria
Syntax
DGET(database, field, criteria)
Parameters
- database: Required. The range of cells that makes up the list or database
- field: Required. Indicates which column is used in the function
- criteria: Required. The range of cells that contains the conditions you specify
Example
=DGET(A1:C10, "Profit", A12:A13)