tdf#139027 Help information for Calc's INDEX() function

Change-Id: I23b4b923329ba6d2783d4a2f02d9e02d3786f708
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/149179
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>

1 files changed, 14 insertions, 10 deletions

diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp
index 1e6d28d8e0..9c4ca09efe 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -179,32 +179,36 @@
 </bookmark>
 <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_INDEX" id="bm_id3157989" localize="false"/>
 <h2 id="hd_id3151221">INDEX</h2>
-<paragraph xml-lang="en-US" id="par_id3150268" role="paragraph"><ahelp hid="HID_FUNC_INDEX">INDEX returns a sub range, specified by row and column number, and/or an optional range index.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="par_id3150268" role="paragraph"><ahelp hid="HID_FUNC_INDEX">INDEX returns a value or an array of values from a reference range, specified by row and column index number or array of row and array of columns index numbers, and an optional range index.</ahelp></paragraph>
          <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
          <paragraph xml-lang="en-US" id="par_id3149007" role="code">INDEX(Reference [; [Row] [; [Column] [; Range]]])</paragraph>
          <paragraph xml-lang="en-US" id="par_id3153260" role="paragraph">
-           <emph>Reference</emph> is a reference, entered either directly or by specifying a range name. If the reference consists of multiple ranges, you must enclose the list of references or range names in parentheses, or use the tilde (~) concatenation/union operator.</paragraph>
+            <emph>Reference</emph> is a reference, entered either directly or by specifying a range name. If the reference consists of multiple ranges, you must enclose the list of references or range names in parentheses, or use the tilde (~) <link href="text/scalc/01/04060199.xhp#referenceoperators">range concatenation operator</link>.</paragraph>
          <paragraph xml-lang="en-US" id="par_id3145302" role="paragraph">
-            <emph>Row</emph> (optional) represents the row index of the reference range, for which to return a value. In case of zero or omitted (no specific row) all referenced rows are returned.</paragraph>
+            <emph>Row</emph> (optional) represents the row or the array of row indexes of the reference range, for which to return a value. In case of zero or omitted (no specific row) all referenced rows are returned.</paragraph>
          <paragraph xml-lang="en-US" id="par_id3154628" role="paragraph">
-            <emph>Column</emph> (optional) represents the column index of the reference range, for which to return a value. In case of zero or omitted (no specific column) all referenced columns are returned.</paragraph>
+            <emph>Column</emph> (optional) represents the column or array of column indexes of the reference range, for which to return a value. In case of zero or omitted (no specific column) all referenced columns are returned.</paragraph>
+         <note id="par_id621679327293280">If <emph>Row</emph>, <emph>Column</emph> or both are ommitted or defined as arrays of indexes, the INDEX function must be entered as an <link href="text/scalc/01/04060107.xhp">array function</link>.</note>
          <paragraph xml-lang="en-US" id="par_id3155514" role="paragraph">
-            <emph>Range</emph> (optional) represents the index of the subrange if referring to a multiple range, default 1.</paragraph>
+            <emph>Range</emph> (optional) represents the index of the subrange if referring to a multiple range, default is 1.</paragraph>
         <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
+        <paragraph role="paragraph" id="par_id541679331443608"><input>{=INDEX({1,3,5;7,9,10},{2;1},1)}</input> return a 2 row array containing 7 and 1. The row index {2;1} pick row 2 then row 1. The columns index 1 picks the first column.</paragraph>
+        <paragraph role="paragraph" id="par_id511679333116273"><input>{=INDEX(D3:G12,{1;2;3;4},{3,1})}</input> return a 4 rows by 2 columns array. The row index array {1;2;3;4} picks rows 3 to 6 and {3;1} picks the third (F) and first column (D). Columns 1 and 3 of the source reference are swapped in the resulting array.</paragraph>
          <paragraph xml-lang="en-US" id="par_id3159112" role="paragraph">
             <item type="input">=INDEX(Prices;4;1)</item> returns the value from row 4 and column 1 of the database range defined in <emph>Data - Define</emph> as <emph>Prices</emph>.</paragraph>
          <paragraph xml-lang="en-US" id="par_id3150691" role="paragraph">
             <item type="input">=INDEX(SumX;4;1)</item> returns the value from the range <emph>SumX</emph> in row 4 and column 1 as defined in <emph>Sheet - Named Ranges and Expressions - Define</emph>.</paragraph>
          <paragraph xml-lang="en-US" id="par_id4109012" role="paragraph">
-            <item type="input">=INDEX(A1:B6;1)</item> returns a reference to the first row of A1:B6.</paragraph>
+            <input>{=INDEX(A1:B6;1)}</input> returns the values of the first row of A1:B6. Enter the formula as an <link href="text/scalc/01/04060107.xhp">array formula</link>.</paragraph>
          <paragraph xml-lang="en-US" id="par_id9272133" role="paragraph">
-            <item type="input">=INDEX(A1:B6;0;1)</item> returns a reference to the first column of A1:B6.</paragraph>
+            <input>{=INDEX(A1:B6;0;1)}</input> returns the values of the first column of A1:B6. Enter the formula as an <link href="text/scalc/01/04060107.xhp">array formula</link>.</paragraph>
          <paragraph xml-lang="en-US" id="par_id3148595" role="paragraph">
             <item type="input">=INDEX(A1:B6;1;1)</item> indicates the value in the upper-left of the A1:B6 range.</paragraph>
          <paragraph xml-lang="en-US" id="par_id9960020" role="paragraph">
-            <item type="input">=INDEX((A1:B6;C1:D6);0;0;2)</item> returns a reference to the second range C1:D6 of the multiple range.</paragraph>
-         <paragraph xml-lang="en-US" id="par_id3158419" role="paragraph">
-           <item type="input">=INDEX(multi;4;1)</item> indicates the value contained in row 4 and column 1 of the (multiple) range, which you named under <emph>Sheet - Named Ranges and Expressions - Define</emph> as <emph>multi</emph> with the expression <emph>(A1:B6;C1:D6)</emph> for example. The multiple range may consist of several rectangular ranges, each with a row 4 and column 1. If you now want to call the second block of this multiple range enter the number <item type="input">2</item> as the <emph>Range</emph> parameter.</paragraph>
+            <input>{=INDEX((A1:B6;C1:D6);0;0;2)}</input> returns the values of the second range C1:D6 of the multiple range. Enter the formula as an <link href="text/scalc/01/04060107.xhp">array formula</link>.</paragraph>
+         <section id="relatedtopics">
+            <tip id="par_id701677016751508"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/INDEX">INDEX wiki page</link>.</tip>
+         </section>
       </section>
       <section id="Section6">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3153181"><bookmark_value>INDIRECT function</bookmark_value>