MATCH now supports modifiers


The MATCH formula function now supports modifiers like "i" to make the match case insensitive.

MATCH("foobar", "[A-Z]", "i")

The list of new modifiers matches the Ruby modifiers here.

See our documentation for more information.