writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: + − + − + − + − + − + − +
no edit summary
=DGET(database, field, criteria)=
=DGET(database, field, criteria)=
<div style="font-size:30px">'''DGET (Array,Field,Criteria,IsGetRows)'''</div><br/>
*Where 'database' is the range of cells that makes up the list or database
*Where 'Array' is the range of cells that makes up the list or database
*'field' shows which column is used in the function and
*'Field' shows which column is used in the function and
*'criteria' is the range of cells that contains the specified criteria.
*'Criteria' is the range of cells that contains the specified criteria.
DGET() obtains a single value from the database that matches the specified criteria.
**DGET(), extracts from a database a single record that matches the specified criteria.
== Description ==
== Description ==
DGET(database, field, criteria)
DGET (Array,Field,Criteria,IsGetRows)
The function obtains a single value from the list or database that matches a 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.
*If more than one records are matching with the given criteria, Calci returns an #N/A error message.
*If more than one records are matching with the given criteria, Calci returns an #N/A error message.