DGET Function Explained
The DGET function in Microsoft Excel is used to extract a single value from a column of a list or database that matches a given criteria. It takes three arguments: database, field, and criteria. The database argument is a range of cells that make up the list or database. The field argument is the column number in the list or database that contains the data you want to extract. The criteria argument is a range of cells that contain the criteria used to select the data.
DGET Function Syntax
DGET(database, field, criteria)
- database: The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields.
- field: The column number in the list range that contains the data you want to retrieve.
- criteria: The range of cells that contains the conditions you specify. The range includes the column labels and criteria.