In this episode, we will talk about Filter, Search and LookUp. These functions look up the records in the table that satisfy the formula. We will learn how to use Filter to find records that match one or more conditions and discard the records that do not match, LookUp to find a single record that matches one or more conditions, and Search to looks up a record in the table that contains a string in multiple columns.