VLOOKUP help [1] mentions "Criterion": > Syntax > =VLOOKUP(SearchCriterion; Array; Index [; SortedRangeLookup]) This word "Criterion" has a specific meaning, is defined in ODF [2], and is used e.g. in SUMIF(S) and the like (see also tdf#131995). On the other hand, VLOOKUP is documented [3] to use Any [4] as its first argument, and it does not work with the syntax like "<=1" that is defined for criterion. The documentation should not use "Criterion" (used as a generic natural-language word), even combined with other words (like "SearchCriterion" here) for arguments that are not related to this defined term, to not cause ambiguity in users. [1] https://help.libreoffice.org/latest/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3153152 [2] http://docs.oasis-open.org/office/OpenDocument/v1.3/OpenDocument-v1.3-part4-formula.html#a_4_11_8_Criterion [3] http://docs.oasis-open.org/office/OpenDocument/v1.3/OpenDocument-v1.3-part4-formula.html#VLOOKUP [4] http://docs.oasis-open.org/office/OpenDocument/v1.3/OpenDocument-v1.3-part4-formula.html#a_4_11_13_Any
Olivier Hallot committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/615a5f87d3f7137b8584d085f9693e8c92dcf296 tdf#141822 Rename parameter for standard compliance