DGET
Extracts from a database a single record that matches the specified criteria.
DatabaseDatabase & Lists
What it does
Extracts a single value from a database column based on specified criteria.
Syntax
DGET(database, field, criteria)
Arguments
database(range) — The range of cells that makes up the list or database.field(text) — The label of the column to retrieve.criteria(range) — The range containing the conditions.
Examples
Get Employee ID
Find ID where Name is 'Alice'.
FORMULA
=DGET(A1:C5, "ID", E1:E2)
RESULT
101
SAMPLE DATA
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Name | ID | Dept | Name | |
| 2 | Alice | 101 | HR | Alice | |
| 3 | Bob | 102 | IT | ||
| 4 | Alice | 103 | Sales |