Bug 161612

Current in part 'MatchType':
0: exact match (default). If Lookup value is not found and NotFound text is omitted, then return the #N/A error.

Error:
The function XMATCH has no parameter 'NotFound'.

Suggested correction:
0: exact match (default). If Lookup value is not found, then return the #N/A error.

-------------------------------------

Current in part 'MatchType':
2: a wildcard match where characters *, ?, and ~ have special meanings.

Problem:
LibreOffice allows not only wildcards but regular expressions as well.

Suggested correction:
2: a wildcard match where characters *, ?, and ~ have special meanings, or a match using regular expressions.

--------------------------------------

Add a warning:
MatchType value 2 cannot be combined with binary search (SearchMode value 2 or -2).

--------------------------------------

Problem:
A help page "Using Regular Expressions in Formulas" is missing.

Add such page and link to it from MatchType value 2 similar as the link on "wildcards". Such link can then be included in XLOOKUP too and in other functions that allow regular expressions.

--------------------------------------

XMATCH is case-insensitive by default. But you can use the mode modifier (?-i) in regular expressions to force search for a case-sensitive match. A corresponding hint is missing. If not the help, then at least the Wiki page should have such hint.