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 the specified conditions. 4 To search for a product number: 1. Copy the range A1:B1. 2. Select cell D1 and press <Ctrl+V>. 3. In cell D2 enter the number 13. 4. In cell E2 type the following formula: =DGET(A1:B10,E1,D1:D2). 5. Press <Enter>. Figure 8-5 204 Chapter 8