source/text/scalc/01/04060109.xhp | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 866f7bdd4933e3c696a4056ce3fab3f90b368930
Author: Mike Kaganski <mike.kagan...@collabora.com>
AuthorDate: Thu Jul 31 06:49:52 2025 +0200
Commit: Mike Kaganski <mike.kagan...@collabora.com>
CommitDate: Thu Jul 31 06:51:52 2025 +0200
Make argument name in different places match
An omission from commit 7179225dccf23dbe347ca6ad88e4eb22cc0abf6a
(Related: tdf#121090: Rewrite descriptions for the last argument
of HLOOKUP/VLOOKUP, 2019-11-11).
Change-Id: I89c53df27147a69112560bb8ffc6ad8a47b8776d
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/188640
Reviewed-by: Mike Kaganski <mike.kagan...@collabora.com>
Tested-by: Jenkins
diff --git a/source/text/scalc/01/04060109.xhp
b/source/text/scalc/01/04060109.xhp
index 214a4a9755..55fb3696dd 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -281,7 +281,7 @@
</bookmark>
<bookmark branch="hid/SC_HID_FUNC_SVERWEIS" id="bm_id3152809"
localize="false"/>
<h2 id="hd_id3153152">VLOOKUP</h2>
-<paragraph id="par_id3149984" role="paragraph"><ahelp
hid="HID_FUNC_SVERWEIS">Vertical search with reference to adjacent cells to the
right.</ahelp> This function checks if a specific value is contained in the
first column of an array. The function then returns the value in the same row
of the column named by <emph>Index</emph>. If the <emph>Sorted</emph> parameter
is omitted or set to TRUE or one, it is assumed that the data is sorted in
ascending order. In this case, if the exact <emph>Lookup</emph> is not found,
the last value that is smaller than the criterion will be returned. If
<emph>Sorted</emph> is set to FALSE or zero, an exact match must be found,
otherwise the error <emph>Error: Value Not Available</emph> will be the result.
Thus with a value of zero the data does not need to be sorted in ascending
order.</paragraph>
+<paragraph id="par_id3149984" role="paragraph"><ahelp
hid="HID_FUNC_SVERWEIS">Vertical search with reference to adjacent cells to the
right.</ahelp> This function checks if a specific value is contained in the
first column of an array. The function then returns the value in the same row
of the column named by <emph>Index</emph>. If the
<emph>SortedRangeLookup</emph> parameter is omitted or set to TRUE or one, it
is assumed that the data is sorted in ascending order. In this case, if the
exact <emph>Lookup</emph> is not found, the last value that is smaller than the
criterion will be returned. If <emph>SortedRangeLookup</emph> is set to FALSE
or zero, an exact match must be found, otherwise the error <emph>Error: Value
Not Available</emph> will be the result. Thus with a value of zero the data
does not need to be sorted in ascending order.</paragraph>
<embed href="text/shared/00/00000001.xhp#regex"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id3150156" role="code">=VLOOKUP(Lookup; Array;
Index [; SortedRangeLookup])</paragraph>
