source/text/scalc/01/04060109.xhp | 7 +
source/text/scalc/01/common_func.xhp | 3
source/text/scalc/01/ful_func.xhp | 3
source/text/scalc/01/func_unique.xhp | 4
source/text/scalc/01/func_xlookup.xhp | 156 ++++++++++------------------------
source/text/scalc/01/func_xmatch.xhp | 14 +--
6 files changed, 67 insertions(+), 120 deletions(-)
New commits:
commit 390dd2b9aaf82a2d859224173364ae207c51ba62
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Sun May 26 14:01:35 2024 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Tue May 28 14:44:48 2024 +0200
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.hal...@libreoffice.org>
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"/>
