update translations for master

and force-fix errors using pocheck

Change-Id: I7aae0544505f037b2eac91c268744de617dc4386

1 files changed, 679 insertions, 40 deletions

diff --git a/source/pt-BR/helpcontent2/source/text/scalc/01.po b/source/pt-BR/helpcontent2/source/text/scalc/01.po
index c5474d32984..7bb2b1878e1 100644
--- a/source/pt-BR/helpcontent2/source/text/scalc/01.po
+++ b/source/pt-BR/helpcontent2/source/text/scalc/01.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: \n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2024-02-02 00:04+0100\n"
+"POT-Creation-Date: 2024-02-28 17:20+0100\n"
 "PO-Revision-Date: 2024-01-12 09:45+0000\n"
 "Last-Translator: Olivier Hallot <olivier.hallot@libreoffice.org>\n"
 "Language-Team: Portuguese (Brazil) <https://translations.documentfoundation.org/projects/libo_help-master/textscalc01/pt_BR/>\n"
@@ -529,42 +529,6 @@ msgctxt ""
 msgid "<ahelp hid=\"modules/scalc/ui/navigatorpanel/documents\">Displays the names of all open documents.</ahelp> To switch to another open document in the Navigator, click the document name. The status (active, inactive) of the document is shown in brackets after the name. You can switch the active document in the <emph>Window</emph> menu."
 msgstr "<ahelp hid=\"modules/scalc/ui/navigatorpanel/documents\">Exibe os nomes de todos os documentos abertos.</ahelp> Para alternar para outro documento aberto no Navegador, clique no nome do documento. O status — ativo ou inativo — do documento é mostrado entre parênteses após o nome. Você também pode alternar o documento ativo no menu <emph>Janela</emph>."
 
-#. 9DPjf
-#: 02120000.xhp
-msgctxt ""
-"02120000.xhp\n"
-"tit\n"
-"help.text"
-msgid "Headers & Footers"
-msgstr "Cabeçalhos e rodapés"
-
-#. Vm7Du
-#: 02120000.xhp
-msgctxt ""
-"02120000.xhp\n"
-"hd_id3145251\n"
-"help.text"
-msgid "<link href=\"text/scalc/01/02120000.xhp\">Headers & Footers</link>"
-msgstr "<link href=\"text/scalc/01/02120000.xhp\">Cabeçalhos e Rodapés</link>"
-
-#. b7G8C
-#: 02120000.xhp
-msgctxt ""
-"02120000.xhp\n"
-"par_id3151073\n"
-"help.text"
-msgid "<variable id=\"kopfundfusszeilentext\"><ahelp hid=\".\">Allows you to define and format headers and footers.</ahelp> </variable>"
-msgstr "<variable id=\"kopfundfusszeilentext\"><ahelp hid=\".\">Permite definir e formatar cabeçalhos e rodapés.</ahelp></variable>"
-
-#. yaZ62
-#: 02120000.xhp
-msgctxt ""
-"02120000.xhp\n"
-"par_id3153415\n"
-"help.text"
-msgid "The <emph>Headers/Footers</emph> dialog contains the tabs for defining headers and footers. There will be separate tabs for the left and right page headers and footers if the <emph>Same content left/right</emph> option was not marked in the <link href=\"text/scalc/01/05070000.xhp\"><emph>Page Style</emph></link> dialog."
-msgstr "A caixa de diálogo <emph>Cabeçalhos/Rodapés</emph> contém as guias para a definição dos cabeçalhos e rodapés. Haverá guias separadas para os cabeçalhos e rodapés das páginas esquerda e direita se a opção <emph>Mesmo conteúdo esquerda/direita</emph> estiver desmarcada na caixa de diálogo <link href=\"text/scalc/01/05070000.xhp\"><emph>Estilo de página</emph></link>."
-
 #. CTq6U
 #: 02120100.xhp
 msgctxt ""
@@ -53332,14 +53296,14 @@ msgctxt ""
 msgid "Insert the document title in the cell. The document title is set in the document properties in <menuitem>File - Properties - Description</menuitem> tab."
 msgstr "Insere o título do documento na célula. O título do documento é definido nas propriedades do documento na aba <menuitem>Arquivo - Propriedades - Descrição</menuitem>"
 
-#. JfG9p
+#. rMdGX
 #: FormatSparklineMenu.xhp
 msgctxt ""
 "FormatSparklineMenu.xhp\n"
 "tit\n"
 "help.text"
-msgid "FormatSparklineMenu"
-msgstr "FormatSparklineMenu"
+msgid "Format Sparkline Menu"
+msgstr ""
 
 #. CGFJG
 #: FormatSparklineMenu.xhp
@@ -62476,6 +62440,60 @@ msgctxt ""
 msgid "<link href=\"text/scalc/05/02140000.xhp\">Error codes</link>"
 msgstr "<link href=\"text/scalc/05/02140000.xhp\">Códigos de erros</link>"
 
+#. qdiU7
+#: func_filter.xhp
+msgctxt ""
+"func_filter.xhp\n"
+"tit\n"
+"help.text"
+msgid "FILTER function"
+msgstr ""
+
+#. uj4VA
+#: func_filter.xhp
+msgctxt ""
+"func_filter.xhp\n"
+"bm_id361708283183878\n"
+"help.text"
+msgid "<bookmark_value>FILTER function</bookmark_value>"
+msgstr ""
+
+#. ymoUm
+#: func_filter.xhp
+msgctxt ""
+"func_filter.xhp\n"
+"hd_id901708806478126\n"
+"help.text"
+msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_filter.xhp\">FILTER</link></variable>"
+msgstr ""
+
+#. XqJ48
+#: func_filter.xhp
+msgctxt ""
+"func_filter.xhp\n"
+"par_id771708806478128\n"
+"help.text"
+msgid "(...)"
+msgstr ""
+
+#. PNSyJ
+#: func_filter.xhp
+msgctxt ""
+"func_filter.xhp\n"
+"par_id211708281649651\n"
+"help.text"
+msgid "FILTER(...)"
+msgstr ""
+
+#. q34Yg
+#: func_filter.xhp
+msgctxt ""
+"func_filter.xhp\n"
+"par_id701677016751508\n"
+"help.text"
+msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/FILTER\">FILTER wiki page</link>."
+msgstr ""
+
 #. sUgSM
 #: func_findb.xhp
 msgctxt ""
@@ -66868,6 +66886,60 @@ msgctxt ""
 msgid "<link href=\"text/scalc/01/04060118.xhp\">Financial Functions Part Three</link>"
 msgstr "<link href=\"text/scalc/01/04060118.xhp\">Funções financeiras - Parte 3</link>"
 
+#. CNANB
+#: func_randarray.xhp
+msgctxt ""
+"func_randarray.xhp\n"
+"tit\n"
+"help.text"
+msgid "RANDARRAY function"
+msgstr ""
+
+#. 2CEfW
+#: func_randarray.xhp
+msgctxt ""
+"func_randarray.xhp\n"
+"bm_id361708283183878\n"
+"help.text"
+msgid "<bookmark_value>RANDARRAY function</bookmark_value>"
+msgstr ""
+
+#. 42Cqg
+#: func_randarray.xhp
+msgctxt ""
+"func_randarray.xhp\n"
+"hd_id901708806478126\n"
+"help.text"
+msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_randarray.xhp\">RANDARRAY</link></variable>"
+msgstr ""
+
+#. 3voMF
+#: func_randarray.xhp
+msgctxt ""
+"func_randarray.xhp\n"
+"par_id771708806478128\n"
+"help.text"
+msgid "(...)"
+msgstr ""
+
+#. n2JxT
+#: func_randarray.xhp
+msgctxt ""
+"func_randarray.xhp\n"
+"par_id211708281649651\n"
+"help.text"
+msgid "RANDARRAY(...)"
+msgstr ""
+
+#. iGDsD
+#: func_randarray.xhp
+msgctxt ""
+"func_randarray.xhp\n"
+"par_id701677016751508\n"
+"help.text"
+msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/RANDARRAY\">RANDARRAY wiki page</link>."
+msgstr ""
+
 #. zr5G3
 #: func_rawsubtract.xhp
 msgctxt ""
@@ -67804,6 +67876,60 @@ msgctxt ""
 msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SECOND\">SECOND wiki page</link>."
 msgstr "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SECOND\">Página wiki da função SEGUNDO</link>."
 
+#. rXRmt
+#: func_sequence.xhp
+msgctxt ""
+"func_sequence.xhp\n"
+"tit\n"
+"help.text"
+msgid "SEQUENCE function"
+msgstr ""
+
+#. Wvq6Q
+#: func_sequence.xhp
+msgctxt ""
+"func_sequence.xhp\n"
+"bm_id361708283183878\n"
+"help.text"
+msgid "<bookmark_value>SEQUENCE function</bookmark_value>"
+msgstr ""
+
+#. PpKCo
+#: func_sequence.xhp
+msgctxt ""
+"func_sequence.xhp\n"
+"hd_id901708806478126\n"
+"help.text"
+msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_sequence.xhp\">SEQUENCE</link></variable>"
+msgstr ""
+
+#. BoGGv
+#: func_sequence.xhp
+msgctxt ""
+"func_sequence.xhp\n"
+"par_id771708806478128\n"
+"help.text"
+msgid "(...)"
+msgstr ""
+
+#. 2wcAc
+#: func_sequence.xhp
+msgctxt ""
+"func_sequence.xhp\n"
+"par_id211708281649651\n"
+"help.text"
+msgid "SEQUENCE(...)"
+msgstr ""
+
+#. sNE2S
+#: func_sequence.xhp
+msgctxt ""
+"func_sequence.xhp\n"
+"par_id701677016751508\n"
+"help.text"
+msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SEQUENCE\">SEQUENCE wiki page</link>."
+msgstr ""
+
 #. JBtM4
 #: func_skewp.xhp
 msgctxt ""
@@ -67894,6 +68020,114 @@ msgctxt ""
 msgid "<link href=\"text/scalc/01/04060185.xhp#skew\">SKEW</link>"
 msgstr "<link href=\"text/scalc/01/04060185.xhp#skew\">DISTORCAO</link>"
 
+#. ZzbFz
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"tit\n"
+"help.text"
+msgid "SORT function"
+msgstr ""
+
+#. Zo6YN
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"bm_id361708283183878\n"
+"help.text"
+msgid "<bookmark_value>SORT function</bookmark_value>"
+msgstr ""
+
+#. Ra8Tv
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"hd_id901708806478126\n"
+"help.text"
+msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_sort.xhp\">SORT</link></variable>"
+msgstr ""
+
+#. 4Ky6H
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"par_id771708806478128\n"
+"help.text"
+msgid "(...)"
+msgstr ""
+
+#. NFc8B
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"par_id211708281649651\n"
+"help.text"
+msgid "SORT(...)"
+msgstr ""
+
+#. JDbrP
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"par_id701677016751508\n"
+"help.text"
+msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SORT\">SORT wiki page</link>."
+msgstr ""
+
+#. wvW3s
+#: func_sortby.xhp
+msgctxt ""
+"func_sortby.xhp\n"
+"tit\n"
+"help.text"
+msgid "SORTBY function"
+msgstr ""
+
+#. u8gwR
+#: func_sortby.xhp
+msgctxt ""
+"func_sortby.xhp\n"
+"bm_id361708283183878\n"
+"help.text"
+msgid "<bookmark_value>SORTBY function</bookmark_value>"
+msgstr ""
+
+#. AcwQa
+#: func_sortby.xhp
+msgctxt ""
+"func_sortby.xhp\n"
+"hd_id901708806478126\n"
+"help.text"
+msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_sortby.xhp\">SORTBY</link></variable>"
+msgstr ""
+
+#. EFPmE
+#: func_sortby.xhp
+msgctxt ""
+"func_sortby.xhp\n"
+"par_id771708806478128\n"
+"help.text"
+msgid "(...)"
+msgstr ""
+
+#. 6QrpC
+#: func_sortby.xhp
+msgctxt ""
+"func_sortby.xhp\n"
+"par_id211708281649651\n"
+"help.text"
+msgid "SORTBY(...)"
+msgstr ""
+
+#. fKeqF
+#: func_sortby.xhp
+msgctxt ""
+"func_sortby.xhp\n"
+"par_id701677016751508\n"
+"help.text"
+msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SORTBY\">SORTBY wiki page</link>."
+msgstr ""
+
 #. CPDEq
 #: func_style.xhp
 msgctxt ""
@@ -69046,6 +69280,60 @@ msgctxt ""
 msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TRUNC\">TRUNC wiki page</link>."
 msgstr "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TRUNC\">Página wiki da função TRUNCAR</link>."
 
+#. 8hfFB
+#: func_unique.xhp
+msgctxt ""
+"func_unique.xhp\n"
+"tit\n"
+"help.text"
+msgid "UNIQUE function"
+msgstr ""
+
+#. CeV2j
+#: func_unique.xhp
+msgctxt ""
+"func_unique.xhp\n"
+"bm_id361708283183878\n"
+"help.text"
+msgid "<bookmark_value>UNIQUE function</bookmark_value>"
+msgstr ""
+
+#. RcWgN
+#: func_unique.xhp
+msgctxt ""
+"func_unique.xhp\n"
+"hd_id901708806478126\n"
+"help.text"
+msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_unique.xhp\">UNIQUE</link></variable>"
+msgstr ""
+
+#. aSANQ
+#: func_unique.xhp
+msgctxt ""
+"func_unique.xhp\n"
+"par_id771708806478128\n"
+"help.text"
+msgid "(...)"
+msgstr ""
+
+#. 24EqX
+#: func_unique.xhp
+msgctxt ""
+"func_unique.xhp\n"
+"par_id211708281649651\n"
+"help.text"
+msgid "UNIQUE(...)"
+msgstr ""
+
+#. oV47W
+#: func_unique.xhp
+msgctxt ""
+"func_unique.xhp\n"
+"par_id701677016751508\n"
+"help.text"
+msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/UNIQUE\">UNIQUE wiki page</link>."
+msgstr ""
+
 #. w86Dm
 #: func_value.xhp
 msgctxt ""
@@ -70495,6 +70783,357 @@ msgctxt ""
 msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/WORKDAY\">WORKDAY wiki page</link>."
 msgstr "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/WORKDAY\">Página wiki da função DIAÚTIL</link>."
 
+#. SHsJ2
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"tit\n"
+"help.text"
+msgid "XLOOKUP Function"
+msgstr ""
+
+#. EFZfF
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"bm_id361708283183878\n"
+"help.text"
+msgid "<bookmark_value>XLOOKUP function</bookmark_value>"
+msgstr ""
+
+#. DDESR
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"hd_id821708279355736\n"
+"help.text"
+msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_xlookup.xhp\">XLOOKUP</link></variable>"
+msgstr ""
+
+#. yC7FC
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id581708279355738\n"
+"help.text"
+msgid "Searches for a value in an array and returns a reference to a cell or range of cells."
+msgstr ""
+
+#. xMTVW
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id631708282151776\n"
+"help.text"
+msgid "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."
+msgstr ""
+
+#. VESoP
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id211708281649651\n"
+"help.text"
+msgid "XLOOKUP(Lookup; Array; Return [; NotFound; MatchType; SearchMode ] )"
+msgstr ""
+
+#. 3zUXb
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id861708281340704\n"
+"help.text"
+msgid "<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>."
+msgstr ""
+
+#. qUjAU
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id831708281625340\n"
+"help.text"
+msgid "<emph>Array</emph>: is the reference of the array or range to search."
+msgstr ""
+
+#. nWhEP
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id241708281629922\n"
+"help.text"
+msgid "<emph>Return</emph>: is the reference of the array or range to return."
+msgstr ""
+
+#. 2LnvD
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id821708357634624\n"
+"help.text"
+msgid "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>."
+msgstr ""
+
+#. 3fY6K
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id271708281637035\n"
+"help.text"
+msgid "<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."
+msgstr ""
+
+#. hBDsh
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id121708281643207\n"
+"help.text"
+msgid "<emph>MatchType</emph>: Specify the match type:"
+msgstr ""
+
+#. aCZbP
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id111708281542144\n"
+"help.text"
+msgid "<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."
+msgstr ""
+
+#. w5rBH
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id851708281548335\n"
+"help.text"
+msgid "<emph>-1</emph> - Exact match. If <emph>Lookup</emph> value is not found, then return the next smaller item."
+msgstr ""
+
+#. zQiND
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id801708281553430\n"
+"help.text"
+msgid "<emph>1</emph> - Exact match. If <emph>Lookup</emph> value is not found, then return the next larger item."
+msgstr ""
+
+#. 4Jxvx
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id881708281558005\n"
+"help.text"
+msgid "<emph>2</emph> - A <link href=\"text/scalc/guide/wildcards.xhp\">wildcard</link> match where characters *, ?, and ~ have special meaning."
+msgstr ""
+
+#. CxCof
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id871708281607313\n"
+"help.text"
+msgid "<emph>SearchMode</emph>: Specify the search mode to use:"
+msgstr ""
+
+#. Lc3bp
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id281708281579757\n"
+"help.text"
+msgid "<emph>1</emph>: - Search starting at the first item (default)."
+msgstr ""
+
+#. HVoEm
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id251708281584285\n"
+"help.text"
+msgid "<emph>-1</emph> - Reverse search starting at the last item."
+msgstr ""
+
+#. CFAD4
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id191708281589997\n"
+"help.text"
+msgid "<emph>2</emph> - Binary search that relies on <emph>Array</emph> being sorted in ascending order. If not sorted, invalid results will be returned."
+msgstr ""
+
+#. mAGCX
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id561708281595885\n"
+"help.text"
+msgid "<emph>-2</emph> - Binary search that relies on <emph>Array</emph> being sorted in descending order. If not sorted, invalid results will be returned."
+msgstr ""
+
+#. vD6hn
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id961708354814163\n"
+"help.text"
+msgid "The table below contains a glossary for translators:"
+msgstr ""
+
+#. MSv55
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id781708353695722\n"
+"help.text"
+msgid "<emph>English</emph>"
+msgstr ""
+
+#. 5G7WA
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id641708353695723\n"
+"help.text"
+msgid "<emph>French</emph>"
+msgstr ""
+
+#. GRDeG
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id671708353695724\n"
+"help.text"
+msgid "<emph>Italian</emph>"
+msgstr ""
+
+#. JfbWn
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id331708353781503\n"
+"help.text"
+msgid "<emph>Japanese</emph>"
+msgstr ""
+
+#. CmUw2
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id31708356677157\n"
+"help.text"
+msgid "<input>={XLOOKUP(\"New\", A2:A4, B2:D4,\"Missing\")}</input> returns the array {\"Nouveau\",\"Nuovo\",\"新しい\"}."
+msgstr ""
+
+#. Z9pX4
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id671708356683379\n"
+"help.text"
+msgid "<input>={XLOOKUP(\"Reload\", A2:A4, B2:D4,\"Missing\")}</input> returns the array {\"Missing\",\"Missing\",\"Missing\"}."
+msgstr ""
+
+#. SzUpN
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id701677016751508\n"
+"help.text"
+msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/XLOOKUP\">XLOOKUP wiki page</link>."
+msgstr ""
+
+#. z6i4f
+#: func_xmatch.xhp
+msgctxt ""
+"func_xmatch.xhp\n"
+"tit\n"
+"help.text"
+msgid "XMATCH Function"
+msgstr ""
+
+#. Q8WY3
+#: func_xmatch.xhp
+msgctxt ""
+"func_xmatch.xhp\n"
+"bm_id361708283183878\n"
+"help.text"
+msgid "<bookmark_value>XMATCH function</bookmark_value>"
+msgstr ""
+
+#. Y5Xci
+#: func_xmatch.xhp
+msgctxt ""
+"func_xmatch.xhp\n"
+"hd_id821708279355736\n"
+"help.text"
+msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_xmatch.xhp\">XMATCH</link></variable>"
+msgstr ""
+
+#. B9dyV
+#: func_xmatch.xhp
+msgctxt ""
+"func_xmatch.xhp\n"
+"par_id581708279355738\n"
+"help.text"
+msgid "Searches for a value in an array or range of cells and returns the relative position of the item."
+msgstr ""
+
+#. MFVXB
+#: func_xmatch.xhp
+msgctxt ""
+"func_xmatch.xhp\n"
+"par_id211708281649651\n"
+"help.text"
+msgid "XMATCH(Lookup; Array [; MatchType; SearchMode ] )"
+msgstr ""
+
+#. NA2BM
+#: func_xmatch.xhp
+msgctxt ""
+"func_xmatch.xhp\n"
+"par_id861708281340704\n"
+"help.text"
+msgid "<emph>Lookup</emph>: The value of any type to search for in <emph>Array</emph>."
+msgstr ""
+
+#. BuCGn
+#: func_xmatch.xhp
+msgctxt ""
+"func_xmatch.xhp\n"
+"par_id831708281625340\n"
+"help.text"
+msgid "<emph>Array</emph>: is the reference of the array or range to search."
+msgstr ""
+
+#. EorAV
+#: func_xmatch.xhp
+msgctxt ""
+"func_xmatch.xhp\n"
+"par_id391708364611193\n"
+"help.text"
+msgid "XMATCH outperforms function MATCH as it allows searches according to the search mode."
+msgstr ""
+
+#. yRpQy
+#: func_xmatch.xhp
+msgctxt ""
+"func_xmatch.xhp\n"
+"par_id31708356677157\n"
+"help.text"
+msgid "<input>=XMATCH(\"Save\", A2:A4, 0, 1)</input> returns 2, the second line of the A2:A4 range."
+msgstr ""
+
+#. 2AAX5
+#: func_xmatch.xhp
+msgctxt ""
+"func_xmatch.xhp\n"
+"par_id701677016751508\n"
+"help.text"
+msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/XMATCH\">XMATCH wiki page</link>."
+msgstr ""
+
 #. dABAX
 #: func_year.xhp
 msgctxt ""