source/text/scalc/01/func_lookup.xhp | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-)
New commits: commit 5da8be137998369addd60a3aa9faf46f3ad74b8a Author: Julien Nabet <[email protected]> AuthorDate: Fri Jul 11 09:10:35 2025 +0200 Commit: Olivier Hallot <[email protected]> CommitDate: Fri Jul 11 13:32:32 2025 +0200 Change argument separator from "," to ";" for LOOKUP Change-Id: Iccd9c2cd5aa1a91bf6230e778cae65a5ee07ed3e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/187677 Tested-by: Jenkins Reviewed-by: Julien Nabet <[email protected]> Reviewed-by: Olivier Hallot <[email protected]> diff --git a/source/text/scalc/01/func_lookup.xhp b/source/text/scalc/01/func_lookup.xhp index f611b724e9..0f1ab89250 100644 --- a/source/text/scalc/01/func_lookup.xhp +++ b/source/text/scalc/01/func_lookup.xhp @@ -41,9 +41,9 @@ <paragraph role="paragraph" id="par_id711750273031297">The table below list the country codes of some countries.</paragraph> <paragraph role="paragraph" id="par_id201750276243814">Source: <link href="https://www.countrycode.org";>https://www.countrycode.org</link></paragraph> <paragraph role="paragraph" id="par_id901750271880106"><image src="media/helpimg/scalc/country_codes.png" id="img_id511750271880109" width="708px" height="598px"><alt id="alt_id941750271880111">Country Codes Samples</alt></image></paragraph> - <paragraph role="paragraph" id="par_id931750273347370"><input>=LOOKUP(46,A2:B34)</input> returns "Sweden", the country which code is 46. Since the result vector is not defined, the function returns the value in the last column of the search array.</paragraph> - <paragraph role="paragraph" id="par_id631750273351969"><input>=LOOKUP(55,A2:A34,D2:D34)</input> returns "BR/BRA", the ISO code for country code 55 (Brazil).</paragraph> - <paragraph role="paragraph" id="par_id1001750273540349"><input>=LOOKUP(7,A2:B34)</input> returns "Russia", the last occurrence of country code 7 in the search array.</paragraph> + <paragraph role="paragraph" id="par_id931750273347370"><input>=LOOKUP(46;A2:B34)</input> returns "Sweden", the country which code is 46. Since the result vector is not defined, the function returns the value in the last column of the search array.</paragraph> + <paragraph role="paragraph" id="par_id631750273351969"><input>=LOOKUP(55;A2:A34,D2:D34)</input> returns "BR/BRA", the ISO code for country code 55 (Brazil).</paragraph> + <paragraph role="paragraph" id="par_id1001750273540349"><input>=LOOKUP(7;A2:B34)</input> returns "Russia", the last occurrence of country code 7 in the search array.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> <embed href="text/scalc/01/ODFF.xhp#odff13"/>
