diff options
| author | Mike Kaganski <mike.kaganski@collabora.com> | 2019-06-10 03:21:22 +0200 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2019-06-10 14:27:47 +0200 |
| commit | a42145547217fb6d12cd873e7af6c71abf301e90 (patch) | |
| tree | ab4ae6ce381a2a6b3b706991ff8dd8f81723a0f6 /source/text/scalc | |
| parent | 2c84c28bc30456c8eb4e0473887ce1d5ff3e4209 (diff) | |
Clarify HLOOKUP/VLOOKUP
Change-Id: I8093a173547850ff0a145a2985a25f46e3ae0297
Reviewed-on: https://gerrit.libreoffice.org/73746
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc')
| -rw-r--r-- | source/text/scalc/01/04060109.xhp | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp index 2a5d6d45bb..5bfce339f6 100644 --- a/source/text/scalc/01/04060109.xhp +++ b/source/text/scalc/01/04060109.xhp @@ -283,7 +283,7 @@ <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>Sorted</emph> is an optional parameter that indicates whether the first column in the array is sorted in ascending order. Enter the Boolean value FALSE or zero if the first column is not sorted in ascending order. Sorted columns can be searched much faster and the function always returns a value, even if the search value was not matched exactly, if it is between the lowest and highest value of the sorted list. In unsorted lists, the search value must be matched exactly. Otherwise the function will return this message: <emph>Error: Value Not Available</emph>.</paragraph> + <emph>Sorted</emph> is an optional parameter that indicates whether the first column in the array is sorted in ascending order. Enter the Boolean value FALSE or zero if the first column is not sorted in ascending order. Sorted columns can be searched much faster and the function always returns a value, even if the search value was 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> @@ -454,7 +454,7 @@ <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; Sorted)</paragraph> - <paragraph xml-lang="en-US" id="par_id3148672" role="paragraph">See also: <link href="text/scalc/01/04060109.xhp#Section9" name="VLOOKUP">VLOOKUP</link> (columns and rows are exchanged)</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"/> </section> <section id="Section18"> |