Syntax. DGET(database,field,criteria)
Definition. This function extracts a value from a column in a list or database that matches the specified conditions.
Arguments
database (required) The cell range that makes up the list or database
field (optional) Indicates which column is used in the function
criteria (required) The cell range containing the field names and the filter criteria
Note
If no record matches the criteria, the DGET() function returns the #VALUE! error. If more than one record matches the criteria, the DGET() function returns the #VALUE! error.
Background. To find a value within a database where a field matches a specific criteria, use the DGET() function.
See Also
You will find more information about search criteria in the section titled Arguments in Database Functions earlier in this chapter.
Example. You are a wholesaler and receive a complaint from one of your customers, Old World Delicatessen. This customer ordered tofu that they say is moldy. To be able to send a complaint to the manufacturer and to ask if there are known production issues, you want to know the date you sold the tofu to Old World Delicatessen. You can use the DGET() function to do this. Because Old World Delicatessen has ordered the tofu, you are sure the DGET() function will return a result.
DGET() returns 12/3/2007 based on the company name, country/region, and item number criteria (B4:D5 as shown in Figure 13-14). Using the DGET() function, you can quickly return values from the database even if you specify several search criteria.
