=LISTITEMCONTAINS
The =LISTITEMCONTAINS() function searches a semicolon-separated list and returns all the list entries that contain the specified text.
Syntax
Section titled “Syntax”=LISTITEMCONTAINS(SearchForText; SemicolonSeparatedList)Parameters
Section titled “Parameters”-
SearchForText
The text to search for within each list item. -
SemicolonSeparatedList
The list of text values to search through.
How It Works
Section titled “How It Works”-
Treats the input as a semicolon-separated list
-
Scans each list entry individually
-
Checks whether the entry contains the specified search text
-
Returns a new semicolon-separated list of only the matching entries
Usage Notes
Section titled “Usage Notes”-
Matching is based on text containment, not exact equality
-
If no list items contain the search text, the function returns an empty value
-
The original list is not modified
-
Useful for filtering lists based on partial matches
-
Formula functions are case sensitive and must be in ALL CAPS
Example
Section titled “Example”=LISTITEMCONTAINS(FindText; ListEntry1; Entry2; FindText3; FindText4; LastEntry5)Returns
FindText3; FindText4
Keywords
Section titled “Keywords”LISTITEMCONTAINS, list filter, contains text, semicolon list, list search, text matching, list functions, formula function, calculated value