Syntax
LookUp(Table, Condition [, ReductionFormula])Examples
LookUp(Employees, Email = User().Email)The current user’s employee record
LookUp(Products, SKU = "A-100", Price)Just the price
Maker notes
- Returns blank when nothing matches.
LookUp
Returns the first record that matches a condition, or one value from it.