Returns the value from a table for the first row that satisfies the filter.
Syntax 1
|
Returns the value from a table for the first row that satisfies the filter. |
|
Lookup(table, returnField, filter) |
|
Arguments: |
|
|
table |
Table - A table. |
|
|
returnField |
Field - The field to return. |
|
|
filter |
Expression - The filter criteria. |
Syntax 2
|
Returns the value from a table for the first row that satisfies the filter. |
|
Lookup(table, returnField, filter, default) |
|
Arguments: |
|
|
table |
Table - A table. |
|
|
returnField |
Field - The field to return. |
|
|
filter |
Expression - The filter criteria. |
|
|
default |
Any - The default return value. |
Remarks
- Example: Lookup(OrdersTable, "CustomerID", "OrderID=" & ID& " AND Region='CENTRAL'") returns 42.
- Example: Lookup(OrdersTable, "CustomerID", "OrderID=" & ID& " AND Region='CENTRAL'", -1) returns -1.
Comments
0 comments
Please sign in to leave a comment.