Microsoft Office Tutorials and References
In Depth Information
Using the DGET Function
Very quickly and without complaint, Excel compares the 5,000 rows of your
database with this complex formula, and the DSUM produces the correct
Figure 12.57. The formula version of the criteria range is rare but incred-
The formula version of the criteria range is rare but incred-
Using the DGET
The DGET function returns a single cell from a database. The problem is that
this function is picky. If your criteria range matches zero records, DGET re-
turns a #VALUE error. If your criteria range returns more than one row, DGET
returns a #NUM! error.
To have DGET work, you need to write a criteria record that causes one and
only one row to be evaluated as TRUE.
The DGET function returns a single cell matching criteria from a data set.
This function takes the following arguments:
database — This is the range of cells that make up the list or data-
base. A databaseis a list of related data in which rows of related
information are records and columns of data are fields. The first row
of the list contains labels for each column.