Syntax
Search(Table, SearchString, Column1 [, Column2, ...])Examples
=Search(Table({Name: "Contoso"}, {Name: "Fabrikam"}), "con", Name)The Contoso row
Maker notes
- Not case-sensitive. An empty search string returns the whole table.
Search
Returns records where any of the listed text columns contains the search text.