see https://help.libreoffice.org/Calc/Spreadsheet_Functions#VLOOKUP and https://help.libreoffice.org/Calc/Spreadsheet_Functions#HLOOKUP have both a parameter SortOrder is optional. Although not listed in the example of VLOOKUP it should be noted. It is easily overseen.
The parameter SortOrder of VLOOKUP is clearly stated as optional. But it is not the case for HLOOKUP. The help page for HLOOKUP indicates that the param's definition are the same as VLOOKUP with columns and rows exchanged. For HLOOKUP I suggest: - Change name of param Sorted to SortOrder, to match VLOOKUP SortOrder. - Change mention of VLOOKUP to a link toward VLOOKUP page.
I just pushed a proposed fix to Gerrit. I don't agree on the Sorted / SortOrder parameter naming: this is a boolean telling if the data is sorted or not, not the order itself. See here: https://gerrit.libreoffice.org/29013 Also the HLOOKUP function has a SearchCriteria parameter, which I think is wrong grammatically as it looks for one value. VLOOKUP has SearchCriterion so it's better to sync with that. See here: https://gerrit.libreoffice.org/29014 The link towards VLOOKUP was fixed in bug #97821.
Gabor Kelemen committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/help/commit/?id=939edb112114cf3e740012a429d1f69a0d1d9bdb tdf#97823 Change VLOOKUP parameter SortOrder to Sorted
Gabor Kelemen committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/help/commit/?id=f3339c932c24d48eb854399d92cd7ca64fe3ea1c tdf#97823 Change SearchCriteria parameter of HLOOKUP