Lookup Functions

  • Updated

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.

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.