diff options
author | Steve Fanning <stevemfanning@yahoo.co.uk> | 2021-02-04 15:07:17 +0100 |
---|---|---|
committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2021-02-05 16:44:54 +0100 |
commit | f654fc362e2ca75a1ff10b772f4b72065484fab2 (patch) | |
tree | 04f9dee8fb5e0f03ba819e0ef7f4aa4ec9baab0e /source/text/scalc | |
parent | tdf#140096 add Ctrl+F6 and Ctrl+Shift+F10 to shortcut keys (diff) | |
download | help-f654fc362e2ca75a1ff10b772f4b72065484fab2.tar.gz help-f654fc362e2ca75a1ff10b772f4b72065484fab2.zip |
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.hallot@libreoffice.org>
Tested-by: Jenkins
Diffstat (limited to 'source/text/scalc')
-rw-r--r-- | source/text/scalc/01/04060109.xhp | 92 |
1 files changed, 92 insertions, 0 deletions
diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp index c695e91650..c571dc97ae 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> |