Extracts a single record from a database that matches specified conditions.
Эта функция в Google Таблицах работает так же, как в Excel — тот же синтаксис и аргументы.
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)Результат: 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.