Excel DGET Function

Use:
Retrieves the unique conditional value in a specified column of a database table
Syntax:
DGET( table , column , criteria )
Examples:
Cell B22 formula: DGET( B2:G9 , "Person" , B12:B13 )

Cell B23 formula: DGET( B2:G9 , "Person" , D12:D13 )
Cell B24 formula: DGET( B2:G9 , "Person" , F12:F15 )
Cell B25 formula: DGET( B2:G9 , "Person" , B17:C18 )
Cell B26 formula: DGET( B2:G9 , "Person" , E17:F19 )

Notes:
Since more than one row satisfies criteria C and E, it not possible to get the name of the person. This is indicated by the #NUM! message. The DGET selection criteria must yield a unique value.

Column can be (1) an integer between one and the number of columns in the table, (2) the unique name of the desired column, or (3) a cell address containing the desired column number or name. For example, the following are equivalent ways to process the Person column:
DGET( B2:G9 , 1 , B12:B13 )
DGET( B2:G9 , "Person" , B12:B13 )
DGET( B2:G9 , D20 , B12:B13 )

Dfunction Overview
Related Functions:
DAVERAGE, DSUM, DCOUNT, DCOUNTA, DMIN, DMAX, DSTDEV, DSTDEVP, DVAR, DVARP