tdf#159872 Review Help XLOOKUP XMATCH functions

From comments in by Regina and Ady in
https://community.documentfoundation.org/t/comments-on-help-for-new-xlookup-fucntion/12086?u=ohallot
and following.

+ Note on "case sensitive"
+ Details on array and range
+ Fix #N/A to "returns the #N/A error"
+ Reworked examples (re-use HLOOKUP table)
+ Grammar and linguistics here and there
+ Fix syntax definition
+ Fix "Not found" definition
+ Fix MatchType using verb "attempt"
+ Position of optional arguments
+ Longer user cases to be addressed in wiki

Note: the function clones Excel XLOOKUP but it is not a copy. Therefore
the name of the arguments were set to differentiate from Excel. The
Calc function arguments usual naming were mostly mnemonic and
not verbose. The current XLOOKUP names in the function wizard is
verbose and has several words. Review is needed.

Patch set 2: fix xml DTD
Patch set 3: XMATCH
+ Reworked example (re-use HLOOKUP table)
+ Link to MATCH
+ Fix function syntax
+ Refactor
Patch set 4:
+ typos
+ Fix case insensitive

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

6 files changed, 67 insertions, 120 deletions

diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp
index fe95792bbd..c0375dee07 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -446,7 +446,9 @@
          <paragraph id="par_id3148672" role="paragraph">For an explanation on the parameters, see: <link href="text/scalc/01/04060109.xhp#Section9">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"/>
-         <paragraph role="paragraph" id="par_id141612447324913">Suppose we have built a small database table occupying the cell range A1:DO4 and containing basic information about 118 chemical elements. The first column contains the row headings “Element”, “Symbol”, “Atomic Number”, and “Relative Atomic Mass”. Subsequent columns contain the relevant information for each of the elements, ordered left to right by atomic number. For example, cells B1:B4 contain “Hydrogen”, “H”, “1” and “1.008”, while cells DO1:DO4 contain “Oganesson”, “Og”, “118”, and “294”.</paragraph>
+
+         <section id="xmpl_periodic_elements">
+    <paragraph role="paragraph" id="par_id141612447324913">Suppose we have built a small database table occupying the cell range A1:DO4 and containing basic information about 118 chemical elements. The first column contains the row headings “Element”, “Symbol”, “Atomic Number”, and “Relative Atomic Mass”. Subsequent columns contain the relevant information for each of the elements, ordered left to right by atomic number. For example, cells B1:B4 contain “Hydrogen”, “H”, “1” and “1.008”, while cells DO1:DO4 contain “Oganesson”, “Og”, “118”, and “294”.</paragraph>
         <table id="tab_id221612450364379">
    <tablerow>
        <tablecell>
@@ -563,7 +565,8 @@
            <paragraph id="par_id461612453928537" role="tablecontent" localize="false">294</paragraph>
        </tablecell>
     </tablerow>
-</table>
+    </table>
+ </section>
         <paragraph role="paragraph" id="par_id51612447346319"><input>=HLOOKUP("Lead"; $A$1:$DO$4; 2; 0)</input> returns “Pb”, the symbol for lead.</paragraph>
          <paragraph role="paragraph" id="par_id291612447349416"><input>=HLOOKUP("Gold"; $A$1:$DO$4; 3; 0)</input> returns 79, the atomic number for gold.</paragraph>
          <paragraph role="paragraph" id="par_id971612447352912"><input>=HLOOKUP("Carbon"; $A$1:$DO$4; 4; 0)</input> returns 12.011, the relative atomic mass of carbon.</paragraph>
diff --git a/source/text/scalc/01/common_func.xhp b/source/text/scalc/01/common_func.xhp
index 8a578b4f46..4a3ac7a323 100644
--- a/source/text/scalc/01/common_func.xhp
+++ b/source/text/scalc/01/common_func.xhp
@@ -36,5 +36,8 @@
     <section id="datenumbersequencenote">
         <note id="par_id301616845402409">This function ignores any text or empty cell within a data range. If you suspect wrong results from this function, look for text in the data ranges. To highlight text contents in a data range, use the <link href="text/scalc/01/03080000.xhp">value highlighting</link> feature.</note>
     </section>
+    <section id="optional_args">
+        <note id="par_id431716730587722">Any of the optional arguments can be omitted. An optional argument is required to be preceded by the preceding separators.</note>
+    </section>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/ful_func.xhp b/source/text/scalc/01/ful_func.xhp
index 1681a65bc6..c31872347b 100644
--- a/source/text/scalc/01/ful_func.xhp
+++ b/source/text/scalc/01/ful_func.xhp
@@ -93,5 +93,8 @@
     <section id="func_volatile">
         <paragraph role="paragraph" id="par_id1001601332672155">This function is always recalculated whenever a recalculation occurs.</paragraph>
     </section>
+    <section id="func_case_sensitive">
+      <note id="par_id711715953325962">The function is always <emph>case insensitive</emph>, independent from the setting of <emph>Case sensitive</emph> checkbox in <switchinline select="sys"><caseinline select="MAC"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline> - <link href="text/shared/optionen/01060500.xhp"><menuitem>%PRODUCTNAME Calc - Calculate</menuitem></link>.</note>
+    </section>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/func_unique.xhp b/source/text/scalc/01/func_unique.xhp
index 8c709cfb44..845a64f193 100644
--- a/source/text/scalc/01/func_unique.xhp
+++ b/source/text/scalc/01/func_unique.xhp
@@ -24,9 +24,7 @@
     <h1 id="hd_id901708806478126"><variable id="h1"><link href="text/scalc/01/func_unique.xhp">UNIQUE</link></variable></h1>
     <paragraph id="par_id771708806478128" role="paragraph">Returns the array of unique values from a range or array of values.</paragraph>
 </section>
-
-<note id="par_id711715953325962">The UNIQUE function is always case sensitive, independent from the setting of <emph>Case sensitive</emph> checkbox in <switchinline select="sys"><caseinline select="MAC"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline> - <link href="text/shared/optionen/01060500.xhp"><menuitem>%PRODUCTNAME Calc - Calculate</menuitem></link>.</note>
-
+<embed href="text/scalc/01/ful_func.xhp#func_case_sensitive"/>
 <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
 <paragraph role="code" id="par_id211708281649651">UNIQUE(Array, [By col], [Uniqueness])</paragraph>
 <paragraph role="paragraph" id="par_id381715698113514"><emph>Array</emph>: the range or array from which to return unique values.</paragraph>
diff --git a/source/text/scalc/01/func_xlookup.xhp b/source/text/scalc/01/func_xlookup.xhp
index 2b2499a17b..c3095969ef 100644
--- a/source/text/scalc/01/func_xlookup.xhp
+++ b/source/text/scalc/01/func_xlookup.xhp
@@ -11,10 +11,10 @@
 
     <meta>
         <topic id="textscalc01func_xlookupxhp" indexer="include" status="PUBLISH">
-        <title id="tit">XLOOKUP Function</title>
-        <filename>/text/scalc/01/func_xlookup.xhp</filename>
-    </topic>
-</meta>
+            <title id="tit">XLOOKUP Function</title>
+            <filename>/text/scalc/01/func_xlookup.xhp</filename>
+        </topic>
+    </meta>
 
 <body>
 <bookmark branch="hid/SC_HID_FUNC_XLOOKUP_MS" id="bm_id501708280229180" localize="false"/>
@@ -25,144 +25,80 @@
     <h1 id="hd_id821708279355736"><variable id="h1"><link href="text/scalc/01/func_xlookup.xhp">XLOOKUP</link></variable></h1>
     <paragraph id="par_id581708279355738" role="paragraph">Searches for a value in an array and returns a reference to a cell or range of cells.</paragraph>
 </section>
-<paragraph role="paragraph" id="par_id631708282151776">XLOOKUP function is a modern and flexible replacement for older functions like <link href="text/scalc/01/04060109.xhp#Section9">VLOOKUP</link>, <link href="text/scalc/01/04060109.xhp#Section17">HLOOKUP</link>, and <link href="text/scalc/01/04060109.xhp#Section14">LOOKUP</link>.  XLOOKUP supports approximate and exact matching, wildcards (* ?) for partial matches, and lookups in vertical or horizontal ranges. XLOOKUP can perform a reverse search and offers a fast binary search option when working with large datasets.</paragraph>
+<paragraph role="paragraph" id="par_id631708282151776">XLOOKUP function is a modern and flexible replacement for older functions like <link href="text/scalc/01/04060109.xhp#Section9">VLOOKUP</link>, <link href="text/scalc/01/04060109.xhp#Section17">HLOOKUP</link>, and <link href="text/scalc/01/04060109.xhp#Section14">LOOKUP</link>. XLOOKUP supports approximate and exact matching, wildcards (* ?) for partial matches, and lookups in vertical or horizontal ranges. XLOOKUP can perform a reverse search and offers a fast binary search option when working with large datasets.</paragraph>
+
 <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
-<paragraph role="code" id="par_id211708281649651">XLOOKUP(Lookup; Array; Return [; NotFound; MatchType; SearchMode ] )</paragraph>
+<paragraph role="code" id="par_id211708281649651">XLOOKUP( [Lookup] ; Array ; Return [ ; [ NotFound ] [ ; [MatchType] [ ; SearchMode ] ] ] )</paragraph>
 
-<paragraph role="paragraph" id="par_id861708281340704"><emph>Lookup</emph>: The value of any type to search for in <emph>Array</emph>. If omitted, XLOOKUP returns blank cells it finds in <emph>Array</emph>.</paragraph>
-<paragraph role="paragraph" id="par_id831708281625340"><emph>Array</emph>: is the reference of the array or range to search.</paragraph>
+<paragraph role="paragraph" id="par_id861708281340704"><emph>Lookup</emph>: (optional) The value of any type to search for in <emph>Array</emph>. If omitted, XLOOKUP returns blank cells it finds in <emph>Array</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id831708281625340"><emph>Array</emph>: is the reference of the array to search.  Array must be a 1-dimensional array and must be contained in one sheet only.</paragraph>
 <paragraph role="paragraph" id="par_id241708281629922"><emph>Return</emph>: is the reference of the array or range to return.</paragraph>
-<note id="par_id821708357634624">If <emph>Return</emph> is an array of values, the XLOOKUP function must be entered as an <link href="text/scalc/01/04060107.xhp#creating_array_formulas">array formula</link>.</note>
-<paragraph role="paragraph" id="par_id271708281637035"><emph>NotFound</emph>: a text to return if the <emph>Lookup</emph> value is not found. If a valid match is not found, and <emph>NotFound</emph> is omitted, returns #N/A.</paragraph>
+<note id="par_id821708357634624">If <emph>Return</emph> is a range of cells, the XLOOKUP function must be entered as an <link href="text/scalc/01/04060107.xhp#creating_array_formulas">array formula</link>.</note>
+<paragraph role="paragraph" id="par_id271708281637035"><emph>NotFound</emph>: a text or cell content to return if the <emph>Lookup</emph> value is not found. If a valid match is not found and <emph>NotFound</emph> is omitted, the function returns the #N/A error.</paragraph>
 
 <section id="matchmode">
-    <paragraph role="paragraph" id="par_id121708281643207"><emph>MatchType</emph>: Specify the match type:</paragraph>
+    <paragraph role="paragraph" id="par_id121708281643207"><emph>MatchType</emph>: (optional) specifies the match type. Values can be:</paragraph>
 <list type="unordered">
     <listitem>
-        <paragraph id="par_id111708281542144"  role="listitem"><emph>0</emph> - Exact match (default). If <emph>Lookup</emph> value is not found and <emph>NotFound</emph> text is omitted, then return #N/A.</paragraph>
+        <paragraph id="par_id111708281542144" role="listitem"><emph>0</emph>: exact match (default). If <emph>Lookup</emph> value is not found and <emph>NotFound</emph> text is omitted, then return the #N/A error.</paragraph>
     </listitem>
     <listitem>
-        <paragraph id="par_id851708281548335"  role="listitem"><emph>-1</emph> - Exact match. If <emph>Lookup</emph> value is not found, then return the next smaller item.</paragraph>
+        <paragraph id="par_id851708281548335" role="listitem"><emph>-1</emph>: attempt exact match. If <emph>Lookup</emph> value is not found, then return the next smaller item.</paragraph>
     </listitem>
     <listitem>
-        <paragraph id="par_id801708281553430"  role="listitem"><emph>1</emph> - Exact match. If <emph>Lookup</emph> value is not found, then return the next larger item.</paragraph>
+        <paragraph id="par_id801708281553430" role="listitem"><emph>1</emph>: attempt exact match. If <emph>Lookup</emph> value is not found, then return the next larger item.</paragraph>
     </listitem>
     <listitem>
-        <paragraph id="par_id881708281558005"  role="listitem"><emph>2</emph> - A <link href="text/scalc/guide/wildcards.xhp">wildcard</link> match where characters *, ?, and ~ have special meaning.</paragraph>
+        <paragraph id="par_id881708281558005" role="listitem"><emph>2</emph>: a <link href="text/scalc/guide/wildcards.xhp">wildcard</link> match where characters *, ?, and ~ have special meanings.</paragraph>
     </listitem>
     </list>
 </section>
 
 <section id="searchmode">
-    <paragraph role="paragraph" id="par_id871708281607313"><emph>SearchMode</emph>: Specify the search mode to use:</paragraph>
+    <paragraph role="paragraph" id="par_id871708281607313"><emph>SearchMode</emph>: (optional) specifies the search mode to use.</paragraph>
+    <embed href="text/scalc/01/ful_func.xhp#func_case_sensitive"/>
 <list type="unordered">
     <listitem>
-        <paragraph id="par_id281708281579757"  role="listitem"><emph>1</emph>: - Search starting at the first item (default).</paragraph>
+        <paragraph id="par_id281708281579757" role="listitem"><emph>1</emph>: returns the first occurrence starting from the first item of <emph>Array</emph> (default).</paragraph>
     </listitem>
     <listitem>
-        <paragraph id="par_id251708281584285"  role="listitem"><emph>-1</emph> - Reverse search starting at the last item.</paragraph>
+        <paragraph id="par_id251708281584285" role="listitem"><emph>-1</emph>: reverse search. Returns the first occurrence starting from the last item of <emph>Array</emph>.</paragraph>
     </listitem>
     <listitem>
-        <paragraph id="par_id191708281589997"  role="listitem"><emph>2</emph> - Binary search that relies on <emph>Array</emph> being sorted in ascending order. If not sorted, invalid results will be returned.</paragraph>
+        <paragraph id="par_id191708281589997" role="listitem"><emph>2</emph>: binary search that relies on <emph>Array</emph> being sorted in ascending order. If not sorted, invalid results will be returned.</paragraph>
     </listitem>
     <listitem>
-        <paragraph id="par_id561708281595885"  role="listitem"><emph>-2</emph> - Binary search that relies on <emph>Array</emph> being sorted in descending order. If not sorted, invalid results will be returned.</paragraph>
+        <paragraph id="par_id561708281595885" role="listitem"><emph>-2</emph>: binary search that relies on <emph>Array</emph> being sorted in descending order. If not sorted, invalid results will be returned.</paragraph>
     </listitem>
     </list>
 </section>
+
+<embed href="text/scalc/01/common_func.xhp#optional_args"/>
+
 <embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
-<section id="xfunc_example">
-    <paragraph role="paragraph" id="par_id961708354814163">The table below contains a glossary for translators:</paragraph>
-<table id="tab_id951708353695721">
-    <tablerow>
-        <tablecell>
-            <paragraph id="par_id401708355378097" localize="false" role="tablehead"></paragraph>
-        </tablecell>
-        <tablecell>
-            <paragraph id="par_id81708355053626" localize="false" role="tablehead">A</paragraph>
-        </tablecell>
-        <tablecell>
-            <paragraph id="par_id771708355056839" localize="false" role="tablehead">B</paragraph>
-        </tablecell>
-        <tablecell>
-            <paragraph id="par_id481708355061087" localize="false" role="tablehead">C</paragraph>
-        </tablecell>
-        <tablecell>
-            <paragraph id="par_id971708355064256" localize="false" role="tablehead">D</paragraph>
-        </tablecell>
-    </tablerow>
-    <tablerow>
-        <tablecell>
-            <paragraph id="par_id601708355403103" localize="false" role="tablehead">1</paragraph>
-        </tablecell>
-        <tablecell>
-            <paragraph id="par_id781708353695722" role="tablecontent"><emph>English</emph></paragraph>
-        </tablecell>
-        <tablecell>
-            <paragraph id="par_id641708353695723" role="tablecontent"><emph>French</emph></paragraph>
-        </tablecell>
-        <tablecell>
-            <paragraph id="par_id671708353695724" role="tablecontent"><emph>Italian</emph></paragraph>
-        </tablecell>
-        <tablecell>
-            <paragraph id="par_id331708353781503" role="tablecontent"><emph>Japanese</emph></paragraph>
-        </tablecell>
-    </tablerow>
-    <tablerow>
-        <tablecell>
-            <paragraph id="par_id931708356090847" localize="false" role="tablehead">2</paragraph>
-        </tablecell>
-        <tablecell>
-            <paragraph id="par_id531708353695725" localize="false" role="tablecontent"><emph>New</emph></paragraph>
-        </tablecell>
-        <tablecell>
-            <paragraph id="par_id151708353695726" localize="false" role="tablecontent">Nouveau</paragraph>
-        </tablecell>
-        <tablecell>
-            <paragraph id="par_id901708353695727" localize="false" role="tablecontent">Nuovo</paragraph>
-        </tablecell>
-        <tablecell>
-            <paragraph id="par_id821708353888675" localize="false" role="tablecontent">新しい</paragraph>
-        </tablecell>
-    </tablerow>
-    <tablerow>
-        <tablecell>
-            <paragraph id="par_id81708356113416" localize="false" role="tablehead">3</paragraph>
-        </tablecell>
-        <tablecell>
-            <paragraph id="par_id791708354354481" localize="false" role="tablecontent"><emph>Save</emph></paragraph>
-        </tablecell>
-        <tablecell>
-            <paragraph id="par_id91708354359320" localize="false" role="tablecontent">Enregistrer</paragraph>
-        </tablecell>
-        <tablecell>
-            <paragraph id="par_id381708354362377" localize="false" role="tablecontent">Salva</paragraph>
-        </tablecell>
-        <tablecell>
-            <paragraph id="par_id881708354364975" localize="false" role="tablecontent">保存</paragraph>
-        </tablecell>
-    </tablerow>
+
+<embed href="text/scalc/01/04060109.xhp#xmpl_periodic_elements"/>
+<paragraph role="paragraph" id="par_id141716739193733"><input>{=XLOOKUP("Atomic Number";A2:A4;A2:DO4)}</input> returns the array</paragraph>
+<table id="tbl_id841716753067380">
     <tablerow>
-        <tablecell>
-            <paragraph id="par_id401708355388097" localize="false" role="tablehead">4</paragraph>
-        </tablecell>
-        <tablecell>
-            <paragraph id="par_id541708354368489" localize="false" role="tablecontent"><emph>Open</emph></paragraph>
-        </tablecell>
-        <tablecell>
-            <paragraph id="par_id991708354371528" localize="false" role="tablecontent">Ouvrir</paragraph>
-        </tablecell>
-        <tablecell>
-            <paragraph id="par_id351708354374560" localize="false" role="tablecontent">Apri</paragraph>
-        </tablecell>
-        <tablecell>
-            <paragraph id="par_id331708354377976" localize="false" role="tablecontent">開ける</paragraph>
-        </tablecell>
+        <tablecell><paragraph id="par_id741716739042699"  localize="false" role="tablecontent">Atomic Number</paragraph></tablecell>
+        <tablecell><paragraph id="par_id261716735499470"  localize="false" role="tablecontent">1</paragraph></tablecell>
+        <tablecell><paragraph id="par_id791716735507557"  localize="false" role="tablecontent">2</paragraph></tablecell>
+        <tablecell><paragraph id="par_id221716735520590"  localize="false" role="tablecontent">3</paragraph></tablecell>
+        <tablecell><paragraph id="par_id351716738989500"  localize="false" role="tablecontent">...</paragraph></tablecell>
+        <tablecell><paragraph id="par_id831716738992540"  localize="false" role="tablecontent">118</paragraph></tablecell>
     </tablerow>
-    </table>
-</section>
-<paragraph role="paragraph" id="par_id31708356677157"><input>={XLOOKUP("New", A2:A4, B2:D4,"Missing")}</input> returns the array {"Nouveau","Nuovo","新しい"}.</paragraph>
-<paragraph role="paragraph" id="par_id671708356683379"><input>={XLOOKUP("Reload", A2:A4, B2:D4,"Missing")}</input> returns the array {"Missing","Missing","Missing"}.</paragraph>
+</table>
+<paragraph role="paragraph" id="par_id231716739652495"><input>{=XLOOKUP("Helium";B1:DO1;B1:DO4)}</input> returns the array</paragraph>
+<table id="tbl_id691716753111818">
+    <tablerow><tablecell><paragraph id="par_id21716739329244" role="tablecontent">Helium</paragraph></tablecell></tablerow>
+    <tablerow><tablecell><paragraph id="par_id181716739331829"  localize="false" role="tablecontent">He</paragraph></tablecell></tablerow>
+    <tablerow><tablecell><paragraph id="par_id121716739334900"  localize="false" role="tablecontent">2</paragraph></tablecell></tablerow>
+    <tablerow><tablecell><paragraph id="par_id41716739337755"  localize="false" role="tablecontent">4.0026</paragraph></tablecell></tablerow>
+</table>
+
+<paragraph role="paragraph" id="par_id671708356683379"><input>{=XLOOKUP("Kryptonite";B1:DO1;B1:DO4;"Unknown element")}</input> returns the array {"Unknown element","Unknown element","Unknown element","Unknown element"}.</paragraph>
+
 <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
 <embed href="text/scalc/00/avail_release.xhp#24.8"/>
 <embed href="text/scalc/01/common_func.xhp#notODFF"/>
diff --git a/source/text/scalc/01/func_xmatch.xhp b/source/text/scalc/01/func_xmatch.xhp
index 5a8d32ca7f..eaad53c503 100644
--- a/source/text/scalc/01/func_xmatch.xhp
+++ b/source/text/scalc/01/func_xmatch.xhp
@@ -22,18 +22,22 @@
 </bookmark>
 <section id="xmatch">
     <h1 id="hd_id821708279355736"><variable id="h1"><link href="text/scalc/01/func_xmatch.xhp">XMATCH</link></variable></h1>
-    <paragraph id="par_id581708279355738" role="paragraph">Searches for a value in an array or range of cells and returns the relative position of the item.</paragraph>
+    <paragraph id="par_id581708279355738" role="paragraph">Searches for a value in an one-dimensional array and returns the relative position of the item.</paragraph>
 </section>
+
+<paragraph role="paragraph" id="par_id321716754048322">XMATCH outperforms function <link href="text/scalc/01/04060109.xhp#Section12">MATCH</link> as it allows searches according to the search mode.</paragraph>
+
 <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
-<paragraph role="code" id="par_id211708281649651">XMATCH(Lookup; Array [; MatchType; SearchMode ] )</paragraph>
+<paragraph role="code" id="par_id211708281649651">XMATCH(Lookup; Array [; MatchType [; SearchMode ] ] )</paragraph>
 <paragraph role="paragraph" id="par_id861708281340704"><emph>Lookup</emph>: The value of any type to search for in <emph>Array</emph>.</paragraph>
 <paragraph role="paragraph" id="par_id831708281625340"><emph>Array</emph>: is the reference of the array or range to search.</paragraph>
 <embed href="text/scalc/01/func_xlookup.xhp#matchmode"/>
 <embed href="text/scalc/01/func_xlookup.xhp#searchmode"/>
-<note id="par_id391708364611193">XMATCH outperforms function MATCH as it allows searches according to the search mode.</note>
+<embed href="text/scalc/01/common_func.xhp#optional_args"/>
 <embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
-<embed href="text/scalc/01/func_xlookup.xhp#xfunc_example"/>
-<paragraph role="paragraph" id="par_id31708356677157"><input>=XMATCH("Save", A2:A4, 0, 1)</input> returns 2, the second line of the A2:A4 range.</paragraph>
+<embed href="text/scalc/01/04060109.xhp#xmpl_periodic_elements"/>
+<paragraph role="paragraph" id="par_id471716753503759"><input>=XMATCH("Atomic Number",A1:A4)</input> returns 3, the third line of the A1:A4 array.</paragraph>
+<paragraph role="paragraph" id="par_id581716753499133"><input>=XMATCH("Li",A2:DO2)</input> returns 4, the fourth column of the A2:DO2 array.</paragraph>
 <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
 <embed href="text/scalc/00/avail_release.xhp#24.8"/>
 <embed href="text/scalc/01/common_func.xhp#notODFF"/>