Extracts a single record from a database that matches specified conditions.
이 함수는 Google Sheets에서도 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.