This function extracts a single value from a specified column within a list or database, based on conditions that you define.
Syntax
DGET(database; field; criteria)
Arguments
- database (required): This is the cell range that constitutes your list or database.
- field (optional): This indicates which column the function should use for extracting the value.
- criteria (required): This is the cell range that contains the field names and the filter criteria you wish to apply.
Background
To find a specific value within a database where a particular field matches certain criteria, use the DGET() function.
Example
Imagine you’re a wholesaler and you’ve received a complaint from a customer, « Old World Delicatessen. » They claim the tofu they ordered is moldy. To submit a complaint to the manufacturer and inquire about any known production issues, you need to find out the exact date you sold that tofu to « Old World Delicatessen. » The DGET() function can help you do this. Since « Old World Delicatessen » definitely ordered the tofu, you can be sure that DGET() will return a result.
DGET() returns 12/3/2007 when using the company name, country/region, and item number as criteria (as shown in B4:D5 in Figure below). By using the DGET() function, you can quickly retrieve values from your database, even when you specify multiple search criteria.
