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.
Olivier Hallot committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/9f43bf5caf95051c06f0c08f326f8d864c501d58 tdf161612 Precisions for XMATCH function Help page
Olivier Hallot committed a patch related to this issue. It has been pushed to "libreoffice-24-8": https://git.libreoffice.org/help/commit/52572824af33a77628c57fe7f6d3e2e19c226b32 tdf161612 Precisions for XMATCH function Help page