source/text/scalc/01/04060109.xhp | 18 +++++++++---------
1 file changed, 9 insertions(+), 9 deletions(-)
New commits:
commit 615a5f87d3f7137b8584d085f9693e8c92dcf296
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Sun Apr 25 16:47:55 2021 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Tue Apr 27 13:03:06 2021 +0200
tdf#141822 Rename parameter for standard compliance
VLOOKUP, HLOOKUP, LOOKUP and MATCH
Change-Id: I348024294f24a5190f0d5054dab2f83355d08567
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/114632
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/04060109.xhp
b/source/text/scalc/01/04060109.xhp
index ec48f0faf..c8aedc337 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -273,18 +273,18 @@
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SVERWEIS" id="bm_id3152809"
localize="false"/>
<h2 id="hd_id3153152">VLOOKUP</h2>
- <paragraph xml-lang="en-US" 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 <item
type="literal">Index</item>. If the <item type="literal">Sorted</item>
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 <item
type="literal">SearchCriterion</item> is not found, the last value that is
smaller than the criterion will be returned. If <item
type="literal">Sorted</item> 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 xml-lang="en-US" 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>
<embed href="text/shared/00/00000001.xhp#regulaer"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph xml-lang="en-US" id="par_id3150156"
role="code">=VLOOKUP(SearchCriterion; Array; Index [;
SortedRangeLookup])</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3150156"
role="code">=VLOOKUP(Lookup; Array; Index [; SortedRangeLookup])</paragraph>
<paragraph xml-lang="en-US" id="par_id3149289" role="paragraph">
- <emph>SearchCriterion</emph> is the value searched for in the
first column of the array.</paragraph>
+ <emph>Lookup</emph> is the value of any type looked for in the
first column of the array.</paragraph>
<paragraph xml-lang="en-US" id="par_id3153884" role="paragraph">
<emph>Array</emph> is the reference, which is to comprise at least
as many columns as the number passed in Index argument.</paragraph>
<paragraph xml-lang="en-US" id="par_id3156005" role="paragraph">
<emph>Index</emph> is the number of the column in the array that
contains the value to be returned. The first column has the number
1.</paragraph>
<paragraph xml-lang="en-US" id="par_id3151208" role="paragraph">
- <emph>SortedRangeLookup</emph> is an optional parameter that
indicates whether the first column in the array contains range boundaries
instead of plain values. In this mode, the lookup returns the value in the row
with first column having value equal to or less than SearchCriterion. E.g., it
could contain dates when some tax value had been changed, and so the values
represent starting dates of a period when a specific tax value was effective.
Thus, searching for a date that is absent in the first array column, but falls
between some existing boundary dates, would give the lower of them, allowing to
find out the data being effective to the searched date. Enter the Boolean value
FALSE or zero if the first column is not a range boundary list. When this
parameter is TRUE or not given, the first column in the array <emph>must be
sorted in ascending order</emph>. Sorted columns can be searched much faster
and the function always returns a value, even if the search value was no
t matched exactly, if it is greater than the lowest value of the sorted list.
In unsorted lists, the search value must be matched exactly. Otherwise the
function will return #N/A with message: <emph>Error: Value Not
Available</emph>.</paragraph>
+ <emph>SortedRangeLookup</emph> is an optional parameter that
indicates whether the first column in the array contains range boundaries
instead of plain values. In this mode, the lookup returns the value in the row
with first column having value equal to or less than <emph>Lookup</emph>. E.g.,
it could contain dates when some tax value had been changed, and so the values
represent starting dates of a period when a specific tax value was effective.
Thus, searching for a date that is absent in the first array column, but falls
between some existing boundary dates, would give the lower of them, allowing to
find out the data being effective to the searched date. Enter the Boolean value
FALSE or zero if the first column is not a range boundary list. When this
parameter is TRUE or not given, the first column in the array <emph>must be
sorted in ascending order</emph>. Sorted columns can be searched much faster
and the function always returns a value, even if the search value w
as not matched exactly, if it is greater than the lowest value of the sorted
list. In unsorted lists, the search value must be matched exactly. Otherwise
the function will return #N/A with message: <emph>Error: Value Not
Available</emph>.</paragraph>
<embed href="text/scalc/05/empty_cells.xhp#empty_cells"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3154129" role="paragraph">You
want to enter the number of a dish on the menu in cell A1, and the name of the
dish is to appear as text in the neighboring cell (B1) immediately. The Number
to Name assignment is contained in the D1:E100 array. D1 contains <item
type="input">100</item>, E1 contains the name <item type="input">Vegetable
Soup</item>, and so forth, for 100 menu items. The numbers in column D are
sorted in ascending order; thus, the optional <item
type="literal">Sorted</item> parameter is not necessary.</paragraph>
@@ -333,9 +333,9 @@
<h2 id="hd_id3158407">MATCH</h2>
<paragraph xml-lang="en-US" id="par_id3154896"
role="paragraph"><ahelp hid="HID_FUNC_VERGLEICH">Returns the relative position
of an item in an array that matches a specified value.</ahelp> The function
returns the position of the value found in the lookup_array as a
number.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph xml-lang="en-US" id="par_id3159152"
role="code">MATCH(SearchCriterion; LookupArray [; Type])</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3159152"
role="code">MATCH(Search; LookupArray [; Type])</paragraph>
<paragraph xml-lang="en-US" id="par_id3149336" role="paragraph">
- <emph>SearchCriterion</emph> is the value which is to be searched
for in the single-row or single-column array.</paragraph>
+ <emph>Search</emph> is the value which is to be searched for in
the single-row or single-column array.</paragraph>
<paragraph xml-lang="en-US" id="par_id3159167" role="paragraph">
<emph>LookupArray</emph> is the reference searched. A lookup array
can be a single row or column, or part of a single row or column.</paragraph>
<paragraph xml-lang="en-US" id="par_id3147239" role="paragraph">
@@ -395,9 +395,9 @@
<note id="par_id4484084">If LOOKUP cannot find the search criterion,
it matches the largest value in the search vector that is less than or equal to
the search criterion.</note>
<embed href="text/shared/00/00000001.xhp#regulaer"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph xml-lang="en-US" id="par_id3154104"
role="code">LOOKUP(SearchCriterion; SearchVector [; ResultVector])</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3154104"
role="code">LOOKUP(Lookup; SearchVector [; ResultVector])</paragraph>
<paragraph xml-lang="en-US" id="par_id3150646" role="paragraph">
- <emph>SearchCriterion</emph> is the value to be searched for;
entered either directly or as a reference.</paragraph>
+ <emph>Lookup</emph> is the value of any type to be looked for;
entered either directly or as a reference.</paragraph>
<paragraph xml-lang="en-US" id="par_id3154854" role="paragraph">
<emph>SearchVector</emph> is the single-row or single-column area
to be searched.</paragraph>
<paragraph xml-lang="en-US" id="par_id3149925" role="paragraph">
@@ -457,7 +457,7 @@
<paragraph xml-lang="en-US" id="par_id3148688"
role="paragraph"><ahelp hid="HID_FUNC_WVERWEIS">Searches for a value and
reference to the cells below the selected area.</ahelp> This function verifies
if the first row of an array contains a certain value. The function returns
then the value in a row of the array, named in the <emph>Index</emph>, in the
same column.</paragraph>
<embed href="text/shared/00/00000001.xhp#regulaer"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph xml-lang="en-US" id="par_id3146070"
role="code">HLOOKUP(SearchCriterion; Array; Index [;
SortedRangeLookup])</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3146070"
role="code">HLOOKUP(Lookup; Array; Index [; SortedRangeLookup])</paragraph>
<paragraph xml-lang="en-US" id="par_id3148672" role="paragraph">For
an explanation on the parameters, see: <link
href="text/scalc/01/04060109.xhp#Section9" name="VLOOKUP">VLOOKUP</link>
(columns and rows are exchanged)</paragraph>
<embed href="text/scalc/05/empty_cells.xhp#empty_cells"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
