INTEGRATION: CWS hcshared17_DEV300 (1.17.2); FILE MERGED

2008/03/04 15:23:56 ufi 1.17.2.1: vor build

1 files changed, 5 insertions, 3 deletions

diff --git a/helpcontent2/source/text/scalc/01/04060109.xhp b/helpcontent2/source/text/scalc/01/04060109.xhp
index a77c23f94b..ee6d059f72 100644
--- a/helpcontent2/source/text/scalc/01/04060109.xhp
+++ b/helpcontent2/source/text/scalc/01/04060109.xhp
@@ -7,9 +7,9 @@
  *
  *  $RCSfile: 04060109.xhp,v $fileonly,v $
  *
- *  $Revision: 1.17 $
+ *  $Revision: 1.18 $
  *
- *  last change: $Author: rt $ $Date: 2008-02-19 22:12:04 $
+ *  last change: $Author: kz $ $Date: 2008-03-07 12:06:46 $
  *
  *  The Contents of this file are made available subject to
  *  the terms of GNU Lesser General Public License Version 2.1.
@@ -182,7 +182,6 @@
 <emph>Column</emph> (optional) represents the column index of the reference range, for which to return a value. In case of zero (no specific column) all referenced columns are returned.</paragraph>
 <paragraph role="paragraph" id="par_id3155514" xml-lang="en-US" l10n="U" oldref="54">
 <emph>Range</emph> (optional) represents the index of the subrange if referring to a multiple range.</paragraph>
-<embedvar href="text/scalc/00/00000004.xhp#optional"/>
 <paragraph role="heading" id="hd_id3145264" xml-lang="en-US" level="3" l10n="U" oldref="55">Example</paragraph>
 <paragraph role="paragraph" id="par_id3159112" xml-lang="en-US" l10n="U" oldref="56">
 <item type="input">=INDEX(Prices;4;1)</item> returns the value from row 4 and column 1 of the database range defined in <emph>Data - Define</emph> as <emph>Prices</emph>.</paragraph>
@@ -339,6 +338,7 @@
 <emph>Index</emph> is the number of the column in the array that contains the value to be returned. The first column has the number 1.</paragraph>
 <paragraph role="paragraph" id="par_id3151208" xml-lang="en-US" l10n="U" oldref="94">
 <emph>SortOrder</emph> is an optional parameter that indicates whether the first column in the array is sorted in ascending order. Enter the Boolean value FALSE or zero if the first column is not sorted in ascending order. Sorted columns can be searched much faster and the function always returns a value, even if the search value was not matched exactly, if it is between the lowest and highest value of the sorted list. In unsorted lists, the search value must be matched exactly. Otherwise the function will return this message: <emph>Error: Value Not Available</emph>.</paragraph>
+<embed href="text/scalc/05/empty_cells.xhp#empty_cells"/>
 <paragraph role="heading" id="hd_id3147487" xml-lang="en-US" level="3" l10n="U" oldref="95">Example</paragraph>
 <paragraph role="paragraph" id="par_id3154129" xml-lang="en-US" l10n="U" oldref="96">You want to enter the number of a dish on the menu in cell A1, and the name of the dish is to appear as text in the neighboring cell (B1) immediately. The Number to Name assignment is contained in the D1:E100 array. D1 contains <item type="input">100</item>, E1 contains the name <item type="input">Vegetable Soup</item>, and so forth, for 100 menu items. The numbers in column D are sorted in ascending order; thus, the optional <item type="literal">SortOrder</item> parameter is not necessary.</paragraph>
 <paragraph role="paragraph" id="par_id3145663" xml-lang="en-US" l10n="U" oldref="97">Enter the following formula in B1:</paragraph>
@@ -446,6 +446,7 @@
 <emph>SearchVector</emph> is the single-row or single-column area to be searched.</paragraph>
 <paragraph role="paragraph" id="par_id3149925" xml-lang="en-US" l10n="U" oldref="129">
 <emph>ResultVector</emph> is another single-row or single-column range from which the result of the function is taken. The result is the cell of the result vector with the same index as the instance found in the search vector.</paragraph>
+<embed href="text/scalc/05/empty_cells.xhp#empty_cells"/>
 <paragraph role="heading" id="hd_id3148624" xml-lang="en-US" level="3" l10n="U" oldref="130">Example</paragraph>
 <paragraph role="paragraph" id="par_id3149809" xml-lang="en-US" l10n="U" oldref="131">
 <item type="input">=LOOKUP(A1;D1:D100;F1:F100)</item> searches the corresponding cell in range D1:D100 for the number you entered in A1. For the instance found, the index is determined, for example, the 12th cell in this range. Then, the contents of the 12th cell are returned as the value of the function (in the result vector).</paragraph>
@@ -499,6 +500,7 @@
 <paragraph role="heading" id="hd_id3154661" xml-lang="en-US" level="3" l10n="U" oldref="153">Syntax</paragraph>
 <paragraph role="code" id="par_id3146070" xml-lang="en-US" l10n="U" oldref="154">HLOOKUP(SearchCriteria; Array; Index; Sorted)</paragraph>
 <paragraph role="paragraph" id="par_id3148672" xml-lang="en-US" l10n="U" oldref="155">See also:<link href="text/scalc/01/04060109.xhp" name="VLOOKUP">VLOOKUP</link> (columns and rows are exchanged)</paragraph>
+<embed href="text/scalc/05/empty_cells.xhp#empty_cells"/>
 </section>
 <section id="Section18">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3147321"><bookmark_value>ROW function</bookmark_value>