1.

Give an example of how to use the LookUp() and Filter() function. What distinguishes it from Filter()?

Answer»

The LookUp() function LOCATES the first record in a database that meets a formula's requirements. LookUp() can be used to locate a single record that meets ONE or more criteria.
Filter(), on the other hand, retrieves all records/items from a database that meet the criteria.

  • LookUp(Table*, Formula [, ReductionFormula]) is the syntax for LookUp() function.

Example: 

LookUp(Cake, FLAVOUR = “Chocolate”, Quantity)
  • Filter(Table*, Formula1 [, Formula2, … ] ) is the syntax for Filter() function.

Example: 

Filter(cake, “chocolate” in LOWER(Flavour ));


Discussion

No Comment Found

Related InterviewSolutions