Extracts a single record from a database that matches specified conditions.
Ta funkcja działa w Arkuszach Google tak samo jak w Excelu — ta sama składnia i argumenty.
DGET(database, field, criteria)The DGET function searches a database for a record that matches the criteria you define. If exactly one record is found, it returns the value from the specified field; if no records or multiple records match, it returns an error.
=DGET(A1:C10, "Price", E1:E2)Wynik: 150
Returns the price from the database where the criteria in E1:E2 match a unique item.
DGET will return the #NUM! error if more than one record matches the criteria.