Microsoft Excel Functions & Formulas

Use the DGET function to search for a

product number

In this example, enter a product number to let Excel search a list

for the corresponding product. To do so, use the DGET function,

which selects a value from a column of a list or database that

matches specified conditions.

DGET(database, field, criteria)

database: The range of cells in the list or database. The first

row of the list contains column headings.

field: Indicates the column to use in the function. field can be

provided as text with the column heading enclosed in double

quotation marks or as a number representing the position of the

column within the list.

criteria: The range of cells containing ...