source/text/scalc/01/04060109.xhp | 92 ++++++++++++++++++++++++++++++++++++++
1 file changed, 92 insertions(+)
New commits:
commit f654fc362e2ca75a1ff10b772f4b72065484fab2
Author: Steve Fanning <stevemfann...@yahoo.co.uk>
AuthorDate: Thu Feb 4 15:07:17 2021 +0100
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Fri Feb 5 16:44:54 2021 +0100
Add Examples section to Help description for Calc's HLOOKUP function.
File 04060109.xhp
Change-Id: If5828bba9aec04564c9eab37f41731ac4d886c1a
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110364
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
Tested-by: Jenkins
diff --git a/source/text/scalc/01/04060109.xhp
b/source/text/scalc/01/04060109.xhp
index c695e9165..c571dc97a 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -458,6 +458,98 @@
<paragraph xml-lang="en-US" id="par_id3146070"
role="code">HLOOKUP(SearchCriterion; Array; Index [;
SortedRangeLookup])</paragraph>
<paragraph xml-lang="en-US" id="par_id3148672" role="paragraph">For
an explanation on the parameters, see: <link
href="text/scalc/01/04060109.xhp#Section9" name="VLOOKUP">VLOOKUP</link>
(columns and rows are exchanged)</paragraph>
<embed href="text/scalc/05/empty_cells.xhp#empty_cells"/>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
+ <paragraph role="paragraph" id="par_id141612447324913">Suppose we
have built a small database table occupying the cell range A1:DO4 and
containing basic information about 118 chemical elements. The first column
contains the row headings “Element”, “Symbol”, “Atomic Number”, and “Relative
Atomic Mass”. Subsequent columns contain the relevant information for each of
the elements, ordered left to right by atomic number. For example, cells B1:B4
contain “Hydrogen”, “H”, “1” and “1.008”, while cells DO1:DO4 contain
“Oganesson”, “Og”, “118”, and “294”.</paragraph>
+ <table id="tab_id221612450364379">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id271612450364379" role="tablehead"
localize="false">A</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id301612450364379" role="tablehead"
localize="false">B</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id551612452808535" role="tablehead"
localize="false">C</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id251612452859597" role="tablehead"
localize="false">...</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id751612450364379" role="tablehead"
localize="false">DO4</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id711612450364379"
role="tablecontent">Hydrogen</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id681612450364379"
role="tablecontent">Helium</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id531612453345232"
role="tablecontent">Lithium</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id951612452954067" role="tablecontent"
localize="false">...</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id571612453039430"
role="tablecontent">Oganesson</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id71612453081581" role="tablecontent"
localize="false">H</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id791612453096630" role="tablecontent"
localize="false">He</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id111612453384301" role="tablecontent"
localize="false">Li</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id921612453115601" role="tablecontent"
localize="false">...</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id161612453127250" role="tablecontent"
localize="false">Og</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id491612453663656" role="tablecontent"
localize="false">1</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id501612453736586" role="tablecontent"
localize="false">2</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id421612453790984" role="tablecontent"
localize="false">3</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id21612453805178" role="tablecontent"
localize="false">...</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id961612453816419" role="tablecontent"
localize="false">118</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id771612453688379" role="tablecontent"
localize="false">1.008</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id281612453852664" role="tablecontent"
localize="false">4.0026</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id431612453888389" role="tablecontent"
localize="false">6.94</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id91612453914383" role="tablecontent"
localize="false">...</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id461612453928537" role="tablecontent"
localize="false">294</paragraph>
+ </tablecell>
+ </tablerow>
+</table>
+ <paragraph role="paragraph"
id="par_id51612447346319"><input>=HLOOKUP("Lead"; $A$1:$DO$4; 2; 0)</input>
returns “Pb”, the symbol for lead.</paragraph>
+ <paragraph role="paragraph"
id="par_id291612447349416"><input>=HLOOKUP("Gold"; $A$1:$DO$4; 3; 0)</input>
returns 79, the atomic number for gold.</paragraph>
+ <paragraph role="paragraph"
id="par_id971612447352912"><input>=HLOOKUP("Carbon"; $A$1:$DO$4; 4; 0)</input>
returns 12.011, the relative atomic mass of carbon.</paragraph>
</section>
<section id="Section18">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3147321"><bookmark_value>ROW function</bookmark_value>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
