Sheet | Lookup Preference | Knowledge Base

Lookup Preference
Regular expressions in formulas
Regular expressions are patterns that can be used to include single or multiple characters in search. While Wildcards can be used for simple searches, regular expressions can be applied for advanced use cases. The patterns used in regular ...
Wildcard characters in formulas
Wildcard characters help you search for terms with iterations of single or multiple characters. Wildcards can be used in formulas such as XLOOKUP to include relevant terms in match. Below is the list of wildcard characters and their use cases: ...

Lookup Preference