Syntax
LookUp(Table, Condition [, ReductionFormula])Examples
=LookUp(Table({Code: "IN", Name: "India"}, {Code: "FR", Name: "France"}), Code = "FR").Name"France"
Maker notes
- Returns blank when nothing matches.
LookUp
Returns the first record that matches a condition, or one value from it.