Merge translation files from master branch.r14.1.x

37 files changed, 2187 insertions, 115 deletions

diff --git a/koffice-i18n-bg/messages/koffice/kspread.po b/koffice-i18n-bg/messages/koffice/kspread.po
index 1bf770f8..69de0a00 100644
--- a/koffice-i18n-bg/messages/koffice/kspread.po
+++ b/koffice-i18n-bg/messages/koffice/kspread.po
@@ -8,7 +8,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2007-05-02 08:18+0000\n"
 "Last-Translator: Zlatko Popov <zlatkopopov@fsa-bg.org>\n"
 "Language-Team: Bulgarian <dict@linux.zonebg.com>\n"
@@ -545,6 +545,7 @@ msgid "Select columns:"
 msgstr "Избор на колони:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Колона"
@@ -12923,7 +12924,7 @@ msgstr "COLUMNS(A1:C3) връща 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) връща 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "Ред"
@@ -13029,7 +13030,8 @@ msgstr "ROWS(A1:C3) връща 3"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) връща 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr "Търсена стойност"
@@ -13074,6 +13076,60 @@ msgstr "LOOKUP(стойност; вектор за търсене; резулт�
 msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr "LOOKUP(1.232; A1:A6; B1:B6) за A1 = 1, A2 = 2 връща стойността на B1."
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "База данни"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Метод (опционално)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-ca/messages/koffice/kspread.po b/koffice-i18n-ca/messages/koffice/kspread.po
index 4c28834a..38aaee85 100644
--- a/koffice-i18n-ca/messages/koffice/kspread.po
+++ b/koffice-i18n-ca/messages/koffice/kspread.po
@@ -9,7 +9,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2006-10-26 20:08+0200\n"
 "Last-Translator: Antoni Bella Pérez <bella5@teleline.es>\n"
 "Language-Team: Catalan <kde-i18n-ca@kde.org>\n"
@@ -547,6 +547,7 @@ msgid "Select columns:"
 msgstr "Seleccioneu les columnes:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Columna"
@@ -12972,7 +12973,7 @@ msgstr "COLUMNS(A1:C3) retorna 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) retorna 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "Fila"
@@ -13079,7 +13080,8 @@ msgstr "ROWS(A1:C3) retorna 3"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) retorna 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr "Valor superior"
@@ -13124,6 +13126,60 @@ msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr ""
 "LOOKUP(1.232; A1:A6; B1:B6) per a A1 = 1, A2 = 2 retorna el valor de B1."
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Base de dades"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Mètode (opcional)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-cs/messages/koffice/kspread.po b/koffice-i18n-cs/messages/koffice/kspread.po
index 6936eced..c9cc53d0 100644
--- a/koffice-i18n-cs/messages/koffice/kspread.po
+++ b/koffice-i18n-cs/messages/koffice/kspread.po
@@ -9,7 +9,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2018-10-22 01:57+0000\n"
 "Last-Translator: Slávek Banko <slavek.banko@axis.cz>\n"
 "Language-Team: Czech <https://mirror.git.trinitydesktop.org/weblate/projects/"
@@ -559,6 +559,7 @@ msgid "Select columns:"
 msgstr "Vybrat sloupce:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Sloupec"
@@ -12708,7 +12709,7 @@ msgstr "COLUMNS(A1:C3) vrací 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) vrací 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, fuzzy, no-c-format
 msgid "Row"
 msgstr "Řádek"
@@ -12808,7 +12809,8 @@ msgstr "ROWS(A1:C3) vrací 3"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) vrací 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, fuzzy, no-c-format
 msgid "Lookup value"
 msgstr "Vrchní hodnota"
@@ -12845,6 +12847,60 @@ msgstr ""
 msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr ""
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Databáze"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Metoda (volitelná)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-cy/messages/koffice/kspread.po b/koffice-i18n-cy/messages/koffice/kspread.po
index c0b94bac..158ca508 100644
--- a/koffice-i18n-cy/messages/koffice/kspread.po
+++ b/koffice-i18n-cy/messages/koffice/kspread.po
@@ -8,7 +8,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2004-09-09 12:35+0100\n"
 "Last-Translator: Kyfieithu <kyfieithu@dotmon.com>\n"
 "Language-Team: Cymraeg <cy@li.org>\n"
@@ -555,6 +555,7 @@ msgid "Select columns:"
 msgstr "Dewis colofnau:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Colofn"
@@ -12977,7 +12978,7 @@ msgstr "Mae COLUMNS(A1:C3) yn dychwelyd 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "Mae COLUMNS(D2) yn dychwelyd 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "Rhes"
@@ -13079,7 +13080,8 @@ msgstr "Mae ROWS(A1:C3) yn dychwelyd 3"
 msgid "ROWS(D2) returns 1"
 msgstr "Mae ROWS(D2) yn dychwelyd 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, fuzzy, no-c-format
 msgid "Lookup value"
 msgstr "Gwerth Pen"
@@ -13116,6 +13118,60 @@ msgstr ""
 msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr ""
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Cronfa Ddata"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Dull (dewisol)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-da/messages/koffice/kspread.po b/koffice-i18n-da/messages/koffice/kspread.po
index 1b85cdcd..e95029ae 100644
--- a/koffice-i18n-da/messages/koffice/kspread.po
+++ b/koffice-i18n-da/messages/koffice/kspread.po
@@ -8,7 +8,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2006-08-25 06:22-0400\n"
 "Last-Translator: Erik Kjær Pedersen <erik@binghamton.edu>\n"
 "Language-Team: Danish <dansk@klid.dk>\n"
@@ -545,6 +545,7 @@ msgid "Select columns:"
 msgstr "Vælg søjler:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Søjle"
@@ -12931,7 +12932,7 @@ msgstr "COLUMNS(A1:C3) giver 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) giver 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "Række"
@@ -13038,7 +13039,8 @@ msgstr "ROWS(A1:C3) giver 3"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) giver 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr "Opslagsværdi"
@@ -13083,6 +13085,60 @@ msgstr "LOOKUP(værdi; opslagsvektor; resultatvektor)"
 msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr "LOOKUP(1,232; A1:A6; B1:B6) for A1 = 1, A2 = 2 giver værdien af B1."
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Database"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Metode (valgfri)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-de/messages/koffice/kspread.po b/koffice-i18n-de/messages/koffice/kspread.po
index 0ea8b21a..c7e50dca 100644
--- a/koffice-i18n-de/messages/koffice/kspread.po
+++ b/koffice-i18n-de/messages/koffice/kspread.po
@@ -14,7 +14,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2020-03-25 00:27+0000\n"
 "Last-Translator: Chris <xchrisx@uber.space>\n"
 "Language-Team: German <https://mirror.git.trinitydesktop.org/weblate/"
@@ -559,6 +559,7 @@ msgid "Select columns:"
 msgstr "Spalten auswählen:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Spalte"
@@ -13138,7 +13139,7 @@ msgstr "COLUMNS(A1:C3) ergibt 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) ergibt 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "Zeile"
@@ -13246,7 +13247,8 @@ msgstr "ROWS(A1:C3) ergibt 3"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) ergibt 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr "Suchwert"
@@ -13290,6 +13292,60 @@ msgstr "LOOKUP(Wert; Suchvektor; Ergebnisvektor)"
 msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr "LOOKUP(1.232; A1:A6; B1:B6) für A1 = 1, A2 = 2 ergibt den Wert von B1."
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Datenbank"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Berechnungsmethode (optional)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-el/messages/koffice/kspread.po b/koffice-i18n-el/messages/koffice/kspread.po
index 83a7ad83..00bc2176 100644
--- a/koffice-i18n-el/messages/koffice/kspread.po
+++ b/koffice-i18n-el/messages/koffice/kspread.po
@@ -8,7 +8,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2007-03-14 15:32+0200\n"
 "Last-Translator: Spiros Georgaras <sng@hellug.gr>\n"
 "Language-Team: Greek <i18ngr@lists.hellug.gr>\n"
@@ -552,6 +552,7 @@ msgid "Select columns:"
 msgstr "Επιλογή στηλών:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Στήλη"
@@ -13117,7 +13118,7 @@ msgstr "COLUMNS(A1:C3) επιστρέφει 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) επιστρέφει 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "Γραμμή"
@@ -13224,7 +13225,8 @@ msgstr "ROWS(A1:C3) επιστρέφει 3"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) επιστρέφει 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr "Τιμή αναζήτησης"
@@ -13271,6 +13273,60 @@ msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr ""
 "LOOKUP(1.232; A1:A6; B1:B6) με A1 = 1, A2 = 2 επιστρέφει την τιμή του B1."
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Βάση δεδομένων"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Μέθοδος (προαιρετικό)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-en_GB/messages/koffice/kspread.po b/koffice-i18n-en_GB/messages/koffice/kspread.po
index 1c18caba..c261da7d 100644
--- a/koffice-i18n-en_GB/messages/koffice/kspread.po
+++ b/koffice-i18n-en_GB/messages/koffice/kspread.po
@@ -8,7 +8,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2006-01-22 11:33+0000\n"
 "Last-Translator: Malcolm Hunter <malcolm.hunter@gmx.co.uk>\n"
 "Language-Team: British English <kde-en-gb@kde.me.uk>\n"
@@ -548,6 +548,7 @@ msgid "Select columns:"
 msgstr "Select columns:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Column"
@@ -13092,7 +13093,7 @@ msgstr "COLUMNS(A1:C3) returns 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) returns 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "Row"
@@ -13198,7 +13199,8 @@ msgstr "ROWS(A1:C3) returns 3"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) returns 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr "Lookup value"
@@ -13243,6 +13245,60 @@ msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr ""
 "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Database"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Method (optional)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-es/messages/koffice/kspread.po b/koffice-i18n-es/messages/koffice/kspread.po
index afe1d341..e4483fa4 100644
--- a/koffice-i18n-es/messages/koffice/kspread.po
+++ b/koffice-i18n-es/messages/koffice/kspread.po
@@ -6,7 +6,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2007-05-03 11:33+0200\n"
 "Last-Translator: Enrique Matias Sanchez (aka Quique) <cronopios@gmail.com>\n"
 "Language-Team: Spanish <es@li.org>\n"
@@ -548,6 +548,7 @@ msgid "Select columns:"
 msgstr "Seleccionar columnas:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Columna"
@@ -13035,7 +13036,7 @@ msgstr "COLUMNS(A1:C3) devuelve 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) devuelve 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "Fila"
@@ -13142,7 +13143,8 @@ msgstr "ROWS(A1:C3) devuelve 3"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) devuelve 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr "Buscar valor"
@@ -13188,6 +13190,60 @@ msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr ""
 "LOOKUP(1.232; A1:A6; B1:B6) para A1 = 1, A2 = 2 devuelve el valor de B1."
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Base de datos"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Método (opcional)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-et/messages/koffice/kspread.po b/koffice-i18n-et/messages/koffice/kspread.po
index 0aa7b8cb..b301a1b4 100644
--- a/koffice-i18n-et/messages/koffice/kspread.po
+++ b/koffice-i18n-et/messages/koffice/kspread.po
@@ -9,7 +9,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2006-08-31 12:52+0200\n"
 "Last-Translator: Marek Laane <bald@starman.ee>\n"
 "Language-Team: Estonian <kde-et@linux.ee>\n"
@@ -546,6 +546,7 @@ msgid "Select columns:"
 msgstr "Valitud veerud:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Veerg"
@@ -12901,7 +12902,7 @@ msgstr "COLUMNS(A1:C3) tagastab 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) tagastab 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "Rida"
@@ -13008,7 +13009,8 @@ msgstr "ROWS(A1:C3) tagastab 3"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) tagastab 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr "Otsimisväärtus"
@@ -13052,6 +13054,60 @@ msgstr "LOOKUP(väärtus; otsimisvektor; tulemusvektor)"
 msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr "LOOKUP(1,232; A1:A6; B1:B6) tagastab, kui A1 = 1, A2 = 2, B1 väärtuse."
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Andmebaas"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Meetod (mittekohustuslik)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-eu/messages/koffice/kspread.po b/koffice-i18n-eu/messages/koffice/kspread.po
index 2c4e7845..a7793872 100644
--- a/koffice-i18n-eu/messages/koffice/kspread.po
+++ b/koffice-i18n-eu/messages/koffice/kspread.po
@@ -5,7 +5,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2005-08-08 23:53-0600\n"
 "Last-Translator: Ion Gaztañaga <igaztanaga@gmail.com>\n"
 "Language-Team: Basque <kdeuskaraz@euskalgnu.org>\n"
@@ -549,6 +549,7 @@ msgid "Select columns:"
 msgstr "Hautatu zutabeak:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Zutabea"
@@ -13065,7 +13066,7 @@ msgstr "COLUMNS(A1:C3) funtzioak 3 itzultzen du"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) funtzioak 1 itzultzen du"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, fuzzy, no-c-format
 msgid "Row"
 msgstr "&Lerroa"
@@ -13167,7 +13168,8 @@ msgstr "ROWS(A1:C3) funtzioak 3 itzultzen du"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) funtzioak 1 itzultzen du"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, fuzzy, no-c-format
 msgid "Lookup value"
 msgstr "Goiko balioa"
@@ -13204,6 +13206,60 @@ msgstr ""
 msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr ""
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Datu-basea"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Metodoa (aukerazkoa)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-fa/messages/koffice/kspread.po b/koffice-i18n-fa/messages/koffice/kspread.po
index 7f242627..539f7791 100644
--- a/koffice-i18n-fa/messages/koffice/kspread.po
+++ b/koffice-i18n-fa/messages/koffice/kspread.po
@@ -9,7 +9,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2007-02-08 09:45+0330\n"
 "Last-Translator: MaryamSadat Razavi <razavi@itland.ir>\n"
 "Language-Team: Persian <kde-i18n-fa@kde.org>\n"
@@ -547,6 +547,7 @@ msgid "Select columns:"
 msgstr "برگزیدن ستونها:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "ستون"
@@ -12891,7 +12892,7 @@ msgstr "COLUMNS(A1:C3)، ۳ را برمی‌گرداند"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2)، ۱ را برمی‌گرداند"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "سطر"
@@ -12995,7 +12996,8 @@ msgstr "ROWS(A1:C3)، ۳ را برمی‌گرداند"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2)، ۱ را برمی‌گرداند"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr "مقدار مراجعه"
@@ -13040,6 +13042,60 @@ msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr ""
 "LOOKUP(1.232; A1:A6; B1:B6) برای A1 = ۱، A2 = ۲ مقدار B1 را برمی‌گرداند."
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "دادگان"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "روش )اختیاری("
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-fi/messages/koffice/kspread.po b/koffice-i18n-fi/messages/koffice/kspread.po
index d23b393c..927b14ca 100644
--- a/koffice-i18n-fi/messages/koffice/kspread.po
+++ b/koffice-i18n-fi/messages/koffice/kspread.po
@@ -10,7 +10,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2005-06-13 15:33+0300\n"
 "Last-Translator: Ilpo Kantonen <ilpo@iki.fi>\n"
 "Language-Team: finnish <Finnish <kde-i18n-fi-discussion@lists.sourceforge."
@@ -553,6 +553,7 @@ msgid "Select columns:"
 msgstr "Valitse sarakkeet:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Sarake"
@@ -12788,7 +12789,7 @@ msgstr "COLUMNS(A1:C3) palauttaa arvon 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) palauttaa arvon 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, fuzzy, no-c-format
 msgid "Row"
 msgstr "&Rivi"
@@ -12886,7 +12887,8 @@ msgstr "ROWS(A1:C3) palauttaa arvon 3"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) palauttaa arvon 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, fuzzy, no-c-format
 msgid "Lookup value"
 msgstr "Ylin arvo"
@@ -12923,6 +12925,60 @@ msgstr ""
 msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr ""
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Tietokanta"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Metodi (valinnainen)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-fr/messages/koffice/kspread.po b/koffice-i18n-fr/messages/koffice/kspread.po
index 96c9de74..282c30e9 100644
--- a/koffice-i18n-fr/messages/koffice/kspread.po
+++ b/koffice-i18n-fr/messages/koffice/kspread.po
@@ -13,7 +13,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2006-09-22 00:06+0200\n"
 "Last-Translator: Matthieu Robin <kde@macolu.org>\n"
 "Language-Team: French <kde-francophone@kde.org>\n"
@@ -555,6 +555,7 @@ msgid "Select columns:"
 msgstr "Sélectionner les colonnes :"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Colonne"
@@ -13060,7 +13061,7 @@ msgstr "COLUMNS(A1:C3) renvoie 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) renvoie 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "Ligne"
@@ -13167,7 +13168,8 @@ msgstr "ROWS(A1:C3) renvoie 3"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) renvoie 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr "Valeur de recherche"
@@ -13212,6 +13214,60 @@ msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr ""
 "LOOKUP(1.232; A1:A6; B1:B6) avec A1 = 1, A2 = 2 retourne la valeur de B1."
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Base de données"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Méthode (optionnel)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-ga/messages/koffice/kspread.po b/koffice-i18n-ga/messages/koffice/kspread.po
index 3c2c28a9..44eb9e8f 100644
--- a/koffice-i18n-ga/messages/koffice/kspread.po
+++ b/koffice-i18n-ga/messages/koffice/kspread.po
@@ -1,7 +1,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: koffice/kspread.po\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2004-12-03 14:52-0500\n"
 "Last-Translator: Kevin Patrick Scannell <scannell@SLU.EDU>\n"
 "Language-Team: ga <LL@li.org>\n"
@@ -532,6 +532,7 @@ msgid "Select columns:"
 msgstr "Roghnaigh colúin:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Colún"
@@ -12523,7 +12524,7 @@ msgstr "Filleann COLUMNS(A1:C3) é seo: 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "Filleann COLUMNS(D2) é seo: 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "Ró"
@@ -12621,7 +12622,8 @@ msgstr "Filleann ROWS(A1:C3) é seo: 3"
 msgid "ROWS(D2) returns 1"
 msgstr "Filleann ROWS(D2) é seo: 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr "Luach cuardaigh"
@@ -12658,6 +12660,60 @@ msgstr ""
 msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr ""
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Bunachar Sonraí"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Cineál (roghnach)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-gl/messages/koffice/kspread.po b/koffice-i18n-gl/messages/koffice/kspread.po
index edb019a6..70d7d2ec 100644
--- a/koffice-i18n-gl/messages/koffice/kspread.po
+++ b/koffice-i18n-gl/messages/koffice/kspread.po
@@ -6,7 +6,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2007-01-14 18:43+0100\n"
 "Last-Translator: Xabi G. Feal <xabigf@gmx.net>\n"
 "Language-Team: Galician <trasno@ceu.fi.udc.es>\n"
@@ -544,6 +544,7 @@ msgid "Select columns:"
 msgstr "Seleccione as colunas:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Coluna"
@@ -12962,7 +12963,7 @@ msgstr "COLUMNS(A1:C3) devolve 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) devolve 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "Fila"
@@ -13069,7 +13070,8 @@ msgstr "ROWS(A1:C3) devolve 3"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) devolve 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr "Valor a procurar"
@@ -13114,6 +13116,60 @@ msgstr "LOOKUP(valor, vector_de_procura, vector_de_resultado)"
 msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr "LOOKUP(1.232; A1:A6; B1:B6) para A1 = 1, A2 = 2 devolve o valor de B1."
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Base de Datos"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Método (opcional)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-hu/messages/koffice/kspread.po b/koffice-i18n-hu/messages/koffice/kspread.po
index 5ba33d08..099d16b7 100644
--- a/koffice-i18n-hu/messages/koffice/kspread.po
+++ b/koffice-i18n-hu/messages/koffice/kspread.po
@@ -3,7 +3,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: KOffice 1.6\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2007-03-26 22:22+0100\n"
 "Last-Translator: Tamas Szanto <tszanto@interware.hu>\n"
 "Language-Team: Hungarian <kde-lista@sophia.jpte.hu>\n"
@@ -540,6 +540,7 @@ msgid "Select columns:"
 msgstr "Oszlop(ok) kiválasztása:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "oszlop"
@@ -12910,7 +12911,7 @@ msgstr "COLUMNS(A1:C3) értéke 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) értéke 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "Sor"
@@ -13012,7 +13013,8 @@ msgstr "ROWS(A1:C3) értéke 3"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) értéke 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr "A keresett érték"
@@ -13049,6 +13051,60 @@ msgstr ""
 msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr ""
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Adatbázis"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Mód (opcionális)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-it/messages/koffice/kspread.po b/koffice-i18n-it/messages/koffice/kspread.po
index 6ec928d6..0c64b5ec 100644
--- a/koffice-i18n-it/messages/koffice/kspread.po
+++ b/koffice-i18n-it/messages/koffice/kspread.po
@@ -10,7 +10,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2022-04-01 15:20+0000\n"
 "Last-Translator: Michele Calgaro <michele.calgaro@yahoo.it>\n"
 "Language-Team: Italian <https://mirror.git.trinitydesktop.org/weblate/"
@@ -553,6 +553,7 @@ msgid "Select columns:"
 msgstr "Seleziona colonne:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Colonna"
@@ -13043,7 +13044,7 @@ msgstr "COLUMNS(A1:C3) restituisce 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) restituisce 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "Riga"
@@ -13150,7 +13151,8 @@ msgstr "ROWS(A1:C3) restituisce 3"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) restituisce 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr "Valore da cercare"
@@ -13197,6 +13199,60 @@ msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr ""
 "LOOKUP(1,232; A1:A6; B1:B6) se A1 = 1 e A2 = 2 restituisce il valore di B1."
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Database"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Metodo (facoltativo)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-ja/messages/koffice/kspread.po b/koffice-i18n-ja/messages/koffice/kspread.po
index e06959c1..6fc80cb5 100644
--- a/koffice-i18n-ja/messages/koffice/kspread.po
+++ b/koffice-i18n-ja/messages/koffice/kspread.po
@@ -6,7 +6,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2006-11-11 18:00+0900\n"
 "Last-Translator: Yukiko Bando <ybando@k6.dion.ne.jp>\n"
 "Language-Team: Japanese <Kdeveloper@kde.gr.jp>\n"
@@ -543,6 +543,7 @@ msgid "Select columns:"
 msgstr "列を選択:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "列"
@@ -12694,7 +12695,7 @@ msgstr "COLUMNS(A1:C3)は3を返します"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2)は1を返します"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "行"
@@ -12796,7 +12797,8 @@ msgstr "ROWS(A1:C3)は3を返します"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2)は1を返します"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr ""
@@ -12833,6 +12835,60 @@ msgstr ""
 msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr "LOOKUP(1.232;A1:A6;B1:B6)はA1=1、A2=2であればB1の値を返します。"
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "データベース"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "方式(オプション)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-lv/messages/koffice/kspread.po b/koffice-i18n-lv/messages/koffice/kspread.po
index 525a1a96..4a12b440 100644
--- a/koffice-i18n-lv/messages/koffice/kspread.po
+++ b/koffice-i18n-lv/messages/koffice/kspread.po
@@ -5,7 +5,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
 "PO-Revision-Date: 2002-03-03 13:22GMT+2\n"
 "Last-Translator: Gints Polis <gintam@inbox.lv>\n"
 "Language-Team: Latviešu <C@li.org>\n"
@@ -589,6 +589,7 @@ msgid "Select columns:"
 msgstr "Dzēst Kolonu(as)"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Kolona"
@@ -13042,7 +13043,7 @@ msgstr "COMBIN(5;5) atgriež 1"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COMBIN(5;5) atgriež 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "Rinda"
@@ -13142,7 +13143,8 @@ msgstr "ODD(1.2) atgriež 3"
 msgid "ROWS(D2) returns 1"
 msgstr "ODD(2) atgriež 3"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, fuzzy, no-c-format
 msgid "Lookup value"
 msgstr "Augšējā vērtība"
@@ -13179,6 +13181,60 @@ msgstr ""
 msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr ""
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Datums"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Teksta opcija"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, fuzzy, no-c-format
 msgid "Statistical"
@@ -17411,10 +17467,6 @@ msgstr "Krāsa/Rāmis"
 #~ msgstr "KSpread Jautājums"
 
 #, fuzzy
-#~ msgid "A1 Style (optional)"
-#~ msgstr "Teksta opcija"
-
-#, fuzzy
 #~ msgid "&Changes"
 #~ msgstr "Mainīt tekstu"
 
@@ -18039,3 +18091,7 @@ msgstr "Krāsa/Rāmis"
 
 #~ msgid "POLA(12;12) returns 16.9705"
 #~ msgstr "POLA(12;12) atgriež 16.9705"
+
+#, fuzzy
+#~ msgid "A1 Style (optional)"
+#~ msgstr "Teksta opcija"
diff --git a/koffice-i18n-ms/messages/koffice/kspread.po b/koffice-i18n-ms/messages/koffice/kspread.po
index 38176bc4..abacb346 100644
--- a/koffice-i18n-ms/messages/koffice/kspread.po
+++ b/koffice-i18n-ms/messages/koffice/kspread.po
@@ -4,7 +4,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: Mimos\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2006-10-05 19:47+0800\n"
 "Last-Translator: Sharuzzaman Ahmat Raslan <sharuzzaman@myrealbox.com>\n"
 "Language-Team: Malay <kedidiemas@yahoogroups.com>\n"
@@ -544,6 +544,7 @@ msgid "Select columns:"
 msgstr "Pilih lajur:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Lajur"
@@ -13044,7 +13045,7 @@ msgstr "COLUMNS(A1:C3) mengembalikan 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) mengembalikan 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, fuzzy, no-c-format
 msgid "Row"
 msgstr "&Baris"
@@ -13146,7 +13147,8 @@ msgstr "ROWS(A1:C3) mengembalikan 3"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) mengembalikan 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, fuzzy, no-c-format
 msgid "Lookup value"
 msgstr "Nilai atas"
@@ -13183,6 +13185,60 @@ msgstr ""
 msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr ""
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Pangkalan Data"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Kaedah (opsyenal)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-nb/messages/koffice/kspread.po b/koffice-i18n-nb/messages/koffice/kspread.po
index d6c9d672..b3d4ff68 100644
--- a/koffice-i18n-nb/messages/koffice/kspread.po
+++ b/koffice-i18n-nb/messages/koffice/kspread.po
@@ -17,7 +17,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2006-10-14 21:59+0200\n"
 "Last-Translator: Bjørn Steensrud <bjornst@powertech.no>\n"
 "Language-Team: Norwegian Bokmål <i18n-no@lister.ping.uio.no>\n"
@@ -561,6 +561,7 @@ msgid "Select columns:"
 msgstr "Velg kolonner:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Kolonne"
@@ -12924,7 +12925,7 @@ msgstr "COLUMNS(A1:C3) gir 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) gir 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "Rad"
@@ -13031,7 +13032,8 @@ msgstr "ROWS(A1:C3) gir 3"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) gir 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr "Oppslagsverdi"
@@ -13076,6 +13078,60 @@ msgstr "LOOKUP(verdi; oppslagsvektor; resultatvektor)"
 msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 gir verdien til B1."
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Database"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Metode (valgfri)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-ne/messages/koffice/kspread.po b/koffice-i18n-ne/messages/koffice/kspread.po
index 276a0349..8dcf48ab 100644
--- a/koffice-i18n-ne/messages/koffice/kspread.po
+++ b/koffice-i18n-ne/messages/koffice/kspread.po
@@ -6,7 +6,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
 "Report-Msgid-Bugs-To: \n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2007-02-12 10:40+0545\n"
 "Last-Translator: Mahesh Subedi <submanesh@gmail.com>\n"
 "Language-Team: Nepali <info@mpp.org.np>\n"
@@ -544,6 +544,7 @@ msgid "Select columns:"
 msgstr "स्तम्भ चयन गर्नुहोस्:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "स्तम्भ"
@@ -12777,7 +12778,7 @@ msgstr "COLUMNS(A1:C3) ले 3 फर्काउँछ"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) ले 1 फर्काउँछ"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "पङ्क्ति"
@@ -12881,7 +12882,8 @@ msgstr "ROWS(A1:C3) ले 3 फर्काउँछ"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) ले 1 फर्काउँछ"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr "मान हेर्नुहोस्"
@@ -12923,6 +12925,60 @@ msgstr "LOOKUP(मान; खोजी भेक्टर; परिणाम �
 msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr "LOOKUP(1.232; A1:A6; B1:B6) का लागि A1 = 1, A2 = 2 B1 का मान फर्काउँछ ।"
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "डाटाबेस"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "विधि (वैकल्पिक)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-nl/messages/koffice/kspread.po b/koffice-i18n-nl/messages/koffice/kspread.po
index c3feaf2c..d9ea841b 100644
--- a/koffice-i18n-nl/messages/koffice/kspread.po
+++ b/koffice-i18n-nl/messages/koffice/kspread.po
@@ -18,7 +18,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2006-08-26 17:44+0200\n"
 "Last-Translator: Bram Schoenmakers <bramschoenmakers@kde.nl>\n"
 "Language-Team: Nederlands <kde-i18n-nl@kde.org>\n"
@@ -563,6 +563,7 @@ msgid "Select columns:"
 msgstr "Kolommen selecteren:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Kolom"
@@ -13208,7 +13209,7 @@ msgstr "COLUMNS(A1:C3) geeft 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) geeft 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "Rij"
@@ -13315,7 +13316,8 @@ msgstr "ROWS(A1:C3) geeft 3"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) geeft 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr "Opzoekwaarde"
@@ -13363,6 +13365,60 @@ msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr ""
 "LOOKUP(1,232; A1:A6; B1:B6) met A1 = 1, A2 = 2 geeft de waarde terug van B1."
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Database"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Methode (optioneel)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-pl/messages/koffice/kspread.po b/koffice-i18n-pl/messages/koffice/kspread.po
index a6fd44a6..b8844b8f 100644
--- a/koffice-i18n-pl/messages/koffice/kspread.po
+++ b/koffice-i18n-pl/messages/koffice/kspread.po
@@ -15,7 +15,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2006-10-04 10:01+0200\n"
 "Last-Translator: Robert Gomulka <rgom@o2.pl>\n"
 "Language-Team: Polish <pl@li.org>\n"
@@ -558,6 +558,7 @@ msgid "Select columns:"
 msgstr "Wybierz kolumny:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Kolumna"
@@ -12968,7 +12969,7 @@ msgstr "COLUMNS(A1:C3) zwraca 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) zwraca 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "Wiersz"
@@ -13075,7 +13076,8 @@ msgstr "ROWS(A1:C3) zwraca 3"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) zwraca 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr "Wartość wyszukiwana"
@@ -13122,6 +13124,60 @@ msgstr ""
 msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr "LOOKUP(1.232; A1:A6; B1:B6) dla A1 = 1, A2 = 2 zwraca wartość B1."
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Baza danych"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Tryb (opcjonalny)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-pt/messages/koffice/kspread.po b/koffice-i18n-pt/messages/koffice/kspread.po
index b52b61f8..8ac2a1ff 100644
--- a/koffice-i18n-pt/messages/koffice/kspread.po
+++ b/koffice-i18n-pt/messages/koffice/kspread.po
@@ -1,7 +1,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2006-08-20 12:48+0100\n"
 "Last-Translator: José Nuno Pires <jncp@netcabo.pt>\n"
 "Language-Team: pt <kde-i18n-pt@kde.org>\n"
@@ -655,6 +655,7 @@ msgid "Select columns:"
 msgstr "Seleccione as colunas:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Coluna"
@@ -13111,7 +13112,7 @@ msgstr "O COLUMNS(A1:C3) devolve 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "O COLUMNS(D2) devolve 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "Linha"
@@ -13218,7 +13219,8 @@ msgstr "O ROWS(A1:C3) devolve 3"
 msgid "ROWS(D2) returns 1"
 msgstr "O ROWS(D2) devolve 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr "Valor da procura"
@@ -13265,6 +13267,60 @@ msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr ""
 "O LOOKUP(1.232; A1:A6; B1:B6) para A1 = 1, A2 = 2 devolve o valor de B1."
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Base de Dados"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Método (opcional)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-pt_BR/messages/koffice/kspread.po b/koffice-i18n-pt_BR/messages/koffice/kspread.po
index f78042e6..7ea1fe45 100644
--- a/koffice-i18n-pt_BR/messages/koffice/kspread.po
+++ b/koffice-i18n-pt_BR/messages/koffice/kspread.po
@@ -4,7 +4,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2019-05-20 16:14+0000\n"
 "Last-Translator: Sebastião Guerra <sebastiao.luiz.guerra@gmail.com>\n"
 "Language-Team: Portuguese (Brazil) <https://mirror.git.trinitydesktop.org/"
@@ -545,6 +545,7 @@ msgid "Select columns:"
 msgstr "Selecionar colunas:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Coluna"
@@ -12955,7 +12956,7 @@ msgstr "COLUMNS(A1:C3) retorna 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) retorna 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "Linha"
@@ -13062,7 +13063,8 @@ msgstr "ROWS(A1:C3) retorna 3"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) retorna 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr "Valor da procura"
@@ -13109,6 +13111,60 @@ msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr ""
 "O LOOKUP(1.232; A1:A6; B1:B6) para A1 = 1, A2 = 2 retorna o valor de B1."
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Banco de dados"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Método (opcional)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-ru/messages/koffice/kspread.po b/koffice-i18n-ru/messages/koffice/kspread.po
index 0b59bfa2..12918396 100644
--- a/koffice-i18n-ru/messages/koffice/kspread.po
+++ b/koffice-i18n-ru/messages/koffice/kspread.po
@@ -10,7 +10,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2024-05-01 20:00+0000\n"
 "Last-Translator: Andrei Stepanov <adem4ik@gmail.com>\n"
 "Language-Team: Russian <https://mirror.git.trinitydesktop.org/weblate/"
@@ -554,6 +554,7 @@ msgid "Select columns:"
 msgstr "Выберите столбцы:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Столбец"
@@ -12972,7 +12973,7 @@ msgstr "COLUMNS(A1:C3) возвратит 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) возвратит 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "Строка"
@@ -13079,7 +13080,8 @@ msgstr "ROWS(A1:C3) возвратит 3"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) возвратит 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr "Поиск значения"
@@ -13122,6 +13124,60 @@ msgstr "LOOKUP(значение; вектор поиска; результиру
 msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr "LOOKUP(1.232; A1:A6; B1:B6) при A1 = 1, A2 = 2 возвратит значение B1."
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "База данных"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Метод (необязательный параметр)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-sk/messages/koffice/kspread.po b/koffice-i18n-sk/messages/koffice/kspread.po
index df345499..ccd3c1a7 100644
--- a/koffice-i18n-sk/messages/koffice/kspread.po
+++ b/koffice-i18n-sk/messages/koffice/kspread.po
@@ -12,7 +12,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2007-01-27 09:42+0100\n"
 "Last-Translator: Richard Fric <Richard.Fric@kdemail.net>\n"
 "Language-Team: Slovak <sk@li.org>\n"
@@ -554,6 +554,7 @@ msgid "Select columns:"
 msgstr "Výber stĺpca:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Stĺpec"
@@ -12776,7 +12777,7 @@ msgstr "COLUMNS(A1:C3) vracia 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) vracia 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, fuzzy, no-c-format
 msgid "Row"
 msgstr "&Riadok"
@@ -12876,7 +12877,8 @@ msgstr "ROWS(A1:C3) vracia 3"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) vracia 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, fuzzy, no-c-format
 msgid "Lookup value"
 msgstr "Horná hranica"
@@ -12913,6 +12915,60 @@ msgstr ""
 msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr ""
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Databáza"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Metóda (voliteľné)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-sl/messages/koffice/kspread.po b/koffice-i18n-sl/messages/koffice/kspread.po
index 05382109..a09d663f 100644
--- a/koffice-i18n-sl/messages/koffice/kspread.po
+++ b/koffice-i18n-sl/messages/koffice/kspread.po
@@ -11,7 +11,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2007-01-07 15:44+0100\n"
 "Last-Translator: Andrej Vernekar <andrej.vernekar@moj.net>\n"
 "Language-Team: Slovenian <translation-team-sl@lists.sourceforge.net>\n"
@@ -552,6 +552,7 @@ msgid "Select columns:"
 msgstr "Izberi stolpce:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Stolpec"
@@ -12812,7 +12813,7 @@ msgstr "COLUMNS(A1:C3) vrne 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) vrne 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "Vrstica"
@@ -12917,7 +12918,8 @@ msgstr "ROWS(A1:C3) vrne 3"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) vrne 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr "Iskana vrednost"
@@ -12954,6 +12956,60 @@ msgstr "LOOKUP(vrednost; preiskovani vektor, vektor rezultata)"
 msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr "LOOKUP(1.232; A1:A6; B1:B6) za A1 = 1, A2 = 2 vrne vrednost celice B1."
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Zbirka podatkov"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Metoda (po želji)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-sr/messages/koffice/kspread.po b/koffice-i18n-sr/messages/koffice/kspread.po
index 18a941a9..58e238a5 100644
--- a/koffice-i18n-sr/messages/koffice/kspread.po
+++ b/koffice-i18n-sr/messages/koffice/kspread.po
@@ -6,7 +6,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2006-11-05 14:41+0100\n"
 "Last-Translator: Chusslove Illich <caslav.ilic@gmx.net>\n"
 "Language-Team: Serbian <kde-yu@kde.org.yu>\n"
@@ -544,6 +544,7 @@ msgid "Select columns:"
 msgstr "Одабери колоне:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Колона"
@@ -12900,7 +12901,7 @@ msgstr "COLUMNS(A1:C3) враћа 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) враћа 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "Врста"
@@ -13005,7 +13006,8 @@ msgstr "ROWS(A1:C3) враћа 3"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) враћа 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr "Вредност за потрагу"
@@ -13049,6 +13051,60 @@ msgstr "LOOKUP(вредност; вектор за потрагу; вектор
 msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr "LOOKUP(1.232; A1:A6; B1:B6) за A1 = 1, A2 = 2 враћа вредност B1."
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "База података"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Метод (опционо)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-sr@Latn/messages/koffice/kspread.po b/koffice-i18n-sr@Latn/messages/koffice/kspread.po
index b5188272..cdd27463 100644
--- a/koffice-i18n-sr@Latn/messages/koffice/kspread.po
+++ b/koffice-i18n-sr@Latn/messages/koffice/kspread.po
@@ -6,7 +6,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2006-11-05 14:41+0100\n"
 "Last-Translator: Chusslove Illich <caslav.ilic@gmx.net>\n"
 "Language-Team: Serbian <kde-yu@kde.org.yu>\n"
@@ -544,6 +544,7 @@ msgid "Select columns:"
 msgstr "Odaberi kolone:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Kolona"
@@ -12905,7 +12906,7 @@ msgstr "COLUMNS(A1:C3) vraća 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) vraća 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "Vrsta"
@@ -13010,7 +13011,8 @@ msgstr "ROWS(A1:C3) vraća 3"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) vraća 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr "Vrednost za potragu"
@@ -13054,6 +13056,60 @@ msgstr "LOOKUP(vrednost; vektor za potragu; vektor rezultata)"
 msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr "LOOKUP(1.232; A1:A6; B1:B6) za A1 = 1, A2 = 2 vraća vrednost B1."
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Baza podataka"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Metod (opciono)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-sv/messages/koffice/kspread.po b/koffice-i18n-sv/messages/koffice/kspread.po
index 281ac5b6..182c1d47 100644
--- a/koffice-i18n-sv/messages/koffice/kspread.po
+++ b/koffice-i18n-sv/messages/koffice/kspread.po
@@ -10,7 +10,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2006-10-14 06:48+0200\n"
 "Last-Translator: Stefan Asserhäll <stefan.asserhall@comhem.se>\n"
 "Language-Team: Swedish <sv@li.org>\n"
@@ -551,6 +551,7 @@ msgid "Select columns:"
 msgstr "Välj kolumner:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Kolumn"
@@ -12986,7 +12987,7 @@ msgstr "COLUMNS(A1:C3) returnerar 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) returnerar 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "Rad"
@@ -13093,7 +13094,8 @@ msgstr "ROWS(A1:C3) returnerar 3"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) returnerar 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr "Uppslagningsvärde"
@@ -13139,6 +13141,60 @@ msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr ""
 "LOOKUP(1,232; A1:A6; B1:B6) för A1 = 1, A2 = 2 returnerar värdet på B1."
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Databas"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Metod (valfri)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-tr/messages/koffice/kspread.po b/koffice-i18n-tr/messages/koffice/kspread.po
index 7bd4e588..006415c3 100644
--- a/koffice-i18n-tr/messages/koffice/kspread.po
+++ b/koffice-i18n-tr/messages/koffice/kspread.po
@@ -10,7 +10,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2006-02-05 15:28+0200\n"
 "Last-Translator: Engin Çağatay <engincagatay@yahoo.com>\n"
 "Language-Team: Türkçe <tr@li.org>\n"
@@ -550,6 +550,7 @@ msgid "Select columns:"
 msgstr "Sütunları seçin:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Sütun"
@@ -12694,7 +12695,7 @@ msgstr "COLUMNS(A1:C3), 3 değerini gönderir"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2), 1 değerini gönderir"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "Satır"
@@ -12794,7 +12795,8 @@ msgstr "ROWS(A1:C3), 3 değerini gönderir"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2), 1 değerini gönderir"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr ""
@@ -12831,6 +12833,60 @@ msgstr ""
 msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr ""
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Veritabanı"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Yöntem (seçmeli)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-uk/messages/koffice/kspread.po b/koffice-i18n-uk/messages/koffice/kspread.po
index e4a6ccd0..10f6e825 100644
--- a/koffice-i18n-uk/messages/koffice/kspread.po
+++ b/koffice-i18n-uk/messages/koffice/kspread.po
@@ -5,7 +5,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2007-05-26 17:12-0700\n"
 "Last-Translator: Ivan Petrouchtchak <ivanpetrouchtchak@yahoo.com>\n"
 "Language-Team: Ukrainian <translation@linux.org.ua>\n"
@@ -547,6 +547,7 @@ msgid "Select columns:"
 msgstr "Виберіть стовпчики:"
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "Стовпчик"
@@ -12669,7 +12670,7 @@ msgstr "COMBIN(5;5) повертає 1"
 msgid "COLUMNS(D2) returns 1"
 msgstr "IMPOWER(\"1.2\";2) повертає 1.44 "
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, fuzzy, no-c-format
 msgid "Row"
 msgstr "Рядок"
@@ -12773,7 +12774,8 @@ msgstr "A1=4;A2=6;IF(A1>A2;5;3) повертає 3"
 msgid "ROWS(D2) returns 1"
 msgstr "IMPOWER(\"1.2\";2) повертає 1.44 "
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, fuzzy, no-c-format
 msgid "Lookup value"
 msgstr "Верхнє значення"
@@ -12810,6 +12812,60 @@ msgstr ""
 msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr ""
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "База даних"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Паро&ль (не обов'язковий):"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, fuzzy, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-zh_CN/messages/koffice/kspread.po b/koffice-i18n-zh_CN/messages/koffice/kspread.po
index e738a2fd..2ae12aea 100644
--- a/koffice-i18n-zh_CN/messages/koffice/kspread.po
+++ b/koffice-i18n-zh_CN/messages/koffice/kspread.po
@@ -10,7 +10,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2006-04-01 12:52+0800\n"
 "Last-Translator: Funda Wang <fundawang@linux.net.cn>\n"
 "Language-Team: zh_CN <i18n-translation@lists.linux.net.cn>\n"
@@ -548,6 +548,7 @@ msgid "Select columns:"
 msgstr "选择列："
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "列"
@@ -12556,7 +12557,7 @@ msgstr "COLUMNS(A1:C3) 返回 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) 返回 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "行"
@@ -12655,7 +12656,8 @@ msgstr "ROWS(A1:C3) 返回 3"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) 返回 1"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr "查阅值"
@@ -12692,6 +12694,60 @@ msgstr "LOOKUP(值;查阅向量;结果向量)"
 msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr "LOOKUP(1.232; A1:A6; B1:B6) 当 A1=1，A2=2 时返回 B1 的值。"
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "数据库"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "方法(可选的)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"
diff --git a/koffice-i18n-zh_TW/messages/koffice/kspread.po b/koffice-i18n-zh_TW/messages/koffice/kspread.po
index 70faf8fe..bdafc7ce 100644
--- a/koffice-i18n-zh_TW/messages/koffice/kspread.po
+++ b/koffice-i18n-zh_TW/messages/koffice/kspread.po
@@ -8,7 +8,7 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 20:19+0000\n"
 "PO-Revision-Date: 2006-08-22 10:21+0800\n"
 "Last-Translator: Frank Weng (a.k.a. Franklin) <franklin at goodhorse dot idv "
 "dot tw>\n"
@@ -549,6 +549,7 @@ msgid "Select columns:"
 msgstr "選擇欄："
 
 #: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
 #, no-c-format
 msgid "Column"
 msgstr "欄"
@@ -12603,7 +12604,7 @@ msgstr "COLUMNS(A1:C3) 傳回 3"
 msgid "COLUMNS(D2) returns 1"
 msgstr "COLUMNS(D2) 傳回 1"
 
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
 #, no-c-format
 msgid "Row"
 msgstr "列"
@@ -12703,7 +12704,8 @@ msgstr "ROWS(A1:C3) 傳回 3"
 msgid "ROWS(D2) returns 1"
 msgstr "ROWS(D2) 傳回 3"
 
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
 #, no-c-format
 msgid "Lookup value"
 msgstr "Lookup 值"
@@ -12745,6 +12747,60 @@ msgstr "LOOKUP(value; lookup vector; result vector)"
 msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
 msgstr "若 A1 = 1，A2 = 2，則 LOOKUP(1.232; A1:A6; B1:B6)傳回 B1 的值。"
 
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "資料庫"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "方法 (選擇性的)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
 #: extensions/statistical.xml:5
 #, no-c-format
 msgid "Statistical"