writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 13:
Line 13: − + Line 19:
Line 19: −
→Description
DGET(database, field, criteria)
DGET(database, field, criteria)
The function obtains a single value from the list or database that matches the specified condition.
The function obtains a single value from the list or database that matches a specified condition.
*A 'field' argument can be expressed as "Salary" (a column name) or 3(position of the column).
*A 'field' argument can be expressed as "Salary" (a column name) or 3(position of the column).
*If no matching records are found, Calci returns an #N/A error message.
*If no matching records are found, Calci returns an #N/A error message.
*Criteria can be any range on the Calci with minimum of one column and at least one row indicating the condition.
*Criteria can be any range on the Calci with minimum of one column and at least one row indicating the condition.
*The Criteria columns should not overlap the list of data.
*The Criteria columns should not overlap the list of data.
== Examples ==
== Examples ==