diff options
| author | Vladimir Glazounov <vg@openoffice.org> | 2006-11-01 16:07:17 +0000 |
|---|---|---|
| committer | Vladimir Glazounov <vg@openoffice.org> | 2006-11-01 16:07:17 +0000 |
| commit | c32b69518b36d4cf7b8d6950d97b42868aff089f (patch) | |
| tree | 635106d21268a15dadeaf8d36acb3fa84d821e21 /helpcontent2/source/text/scalc/01/04060109.xhp | |
| parent | 176129a0af9024aa14bede5f0a54ebc34b3c4fba (diff) | |
INTEGRATION: CWS hcshared05 (1.10.20); FILE MERGED
2006/10/10 13:04:26 ufi 1.10.20.2: RESYNC: (1.10-1.11); FILE MERGED
2006/09/26 14:37:57 ufi 1.10.20.1: ready
Diffstat (limited to 'helpcontent2/source/text/scalc/01/04060109.xhp')
| -rw-r--r-- | helpcontent2/source/text/scalc/01/04060109.xhp | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060109.xhp b/helpcontent2/source/text/scalc/01/04060109.xhp index 48bae877a8..6a1e998c6e 100644 --- a/helpcontent2/source/text/scalc/01/04060109.xhp +++ b/helpcontent2/source/text/scalc/01/04060109.xhp @@ -6,9 +6,9 @@ * * $RCSfile: 04060109.xhp,v $ * - * $Revision: 1.11 $ + * $Revision: 1.12 $ * - * last change: $Author: kz $ $Date: 2006-10-05 12:59:06 $ + * last change: $Author: vg $ $Date: 2006-11-01 17:07:17 $ * * The Contents of this file are made available subject to * the terms of GNU Lesser General Public License Version 2.1. @@ -44,7 +44,7 @@ </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2006-07-18T13:13:42">UFI: brushed up this doc due to #i29327# +<lastedited date="2006-09-22T10:33:19">UFI: brushed up this doc due to #i29327# dedr: reviewed UFI: added HYPERLINK function #i27972#; dedr. reviewed</lastedited> </history> @@ -317,7 +317,7 @@ UFI: added HYPERLINK function #i27972#; dedr. reviewed</lastedited> </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_FUNC_SVERWEIS" id="bm_id3152809" localize="false"/> <paragraph role="heading" id="hd_id3153152" xml-lang="en-US" level="2" l10n="U" oldref="87">VLOOKUP</paragraph> -<paragraph role="paragraph" id="par_id3149984" xml-lang="en-US" l10n="U" oldref="88"><ahelp hid="HID_FUNC_SVERWEIS">Vertical search with reference to adjacent cells to the right.</ahelp> This function checks if a specific value is contained in the first column of an array. The function then returns the value to the same line of a specific array column named by index.</paragraph> +<paragraph role="paragraph" id="par_id3149984" xml-lang="en-US" l10n="CHG" oldref="88"><ahelp hid="HID_FUNC_SVERWEIS">Vertical search with reference to adjacent cells to the right.</ahelp> This function checks if a specific value is contained in the first column of an array. The function then returns the value in the same row of the column named by <emph>index</emph>. If the <emph>Sort order</emph> parameter is omitted or set to TRUE, it is assumed that the data is sorted in ascending order. In this case, if the exact <emph>search criterion</emph> is not found, the next value will be returned. If <emph>Sort order</emph> is set to FALSE or zero, an exact match must be found, otherwise the error <emph>Error: Value Not Available</emph> will be the result. Thus with a value of zero the data does not need to be sorted in ascending order.</paragraph> <embed href="text/shared/00/00000001.xhp#regulaer"/> <paragraph role="heading" id="hd_id3146898" xml-lang="en-US" level="3" l10n="U" oldref="89">Syntax</paragraph> <paragraph role="code" id="par_id3150156" xml-lang="en-US" l10n="U" oldref="90">=VLOOKUP(Search criterion;array;index;Sort order)</paragraph> |