[FAQ000179]Does CELF’s VLOOKUP function support the wildcard "*"?

Q

Does CELF’s VLOOKUP function support the wildcard "*"?

A

CELF’s VLOOKUP function does not support the wildcard "*".

To perform fuzzy search, the following methods are possible

１．

Master the data in a table

and perform a search using the "Get multiple records from table[]" action or SQL action.

２．

Combine "Repeat if [] is fulfilled" action

and the UTIL.REGEXP function (regular expression) to perform the search.

Example of use)

=UTIL.REGEXP("Person in charge of business1",A1)

If cell A1 includes "Person in charge of business1", return true.

Related keywords

Fuzzy search