diff options
| author | Rüdiger Timm <rt@openoffice.org> | 2007-04-02 13:54:25 +0000 |
|---|---|---|
| committer | Rüdiger Timm <rt@openoffice.org> | 2007-04-02 13:54:25 +0000 |
| commit | 0c5afded286f1537633d6cd3255b4cb214eb7620 (patch) | |
| tree | dace000cf65d1b305231d439c426be74f622c057 | |
| parent | INTEGRATION: CWS hcshared08 (1.10.2); FILE MERGED (diff) | |
| download | help-0c5afded286f1537633d6cd3255b4cb214eb7620.tar.gz help-0c5afded286f1537633d6cd3255b4cb214eb7620.zip | |
INTEGRATION: CWS hcshared08 (1.12.26); FILE MERGED
2007/03/05 08:06:42 ufi 1.12.26.1: last commit
| -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 6a1e998c6e..cc15af93dd 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.12 $ + * $Revision: 1.13 $ * - * last change: $Author: vg $ $Date: 2006-11-01 17:07:17 $ + * last change: $Author: rt $ $Date: 2007-04-02 14:54:25 $ * * 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-09-22T10:33:19">UFI: brushed up this doc due to #i29327# +<lastedited date="2007-02-26T16:56:44">UFI: brushed up this doc due to #i29327# dedr: reviewed UFI: added HYPERLINK function #i27972#; dedr. reviewed</lastedited> </history> @@ -413,7 +413,7 @@ UFI: added HYPERLINK function #i27972#; dedr. reviewed</lastedited> </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_FUNC_VERWEIS" id="bm_id3152877" localize="false"/> <paragraph role="heading" id="hd_id3159273" xml-lang="en-US" level="2" l10n="U" oldref="123">LOOKUP</paragraph> -<paragraph role="paragraph" id="par_id3153389" xml-lang="en-US" l10n="U" oldref="124"><ahelp hid="HID_FUNC_VERWEIS">Returns the contents of a cell either from a one-row or one-column range or from an array.</ahelp> Optionally, the assigned value (of the same index) is returned in a different column and row. As opposed to <link href="text/scalc/01/04060109.xhp" name="VLOOKUP">VLOOKUP</link> and <link href="text/scalc/01/04060109.xhp" name="HLOOKUP">HLOOKUP</link>, search and result vector may be at different positions; they do not have to be adjacent. Additionally, the search vector for the LOOKUP must be sorted, otherwise the search will not return any usable results.</paragraph> +<paragraph role="paragraph" id="par_id3153389" xml-lang="en-US" l10n="CHG" oldref="124"><ahelp hid="HID_FUNC_VERWEIS">Returns the contents of a cell either from a one-row or one-column range.</ahelp> Optionally, the assigned value (of the same index) is returned in a different column and row. As opposed to <link href="text/scalc/01/04060109.xhp" name="VLOOKUP">VLOOKUP</link> and <link href="text/scalc/01/04060109.xhp" name="HLOOKUP">HLOOKUP</link>, search and result vector may be at different positions; they do not have to be adjacent. Additionally, the search vector for the LOOKUP must be sorted, otherwise the search will not return any usable results.</paragraph> <paragraph role="note" id="par_id4484084" xml-lang="en-US" l10n="NEW">If LOOKUP cannot find the search criterion, it matches the largest value in the search vector that is less than or equal to the search criterion.</paragraph> <embed href="text/shared/00/00000001.xhp#regulaer"/> <paragraph role="heading" id="hd_id3152947" xml-lang="en-US" level="3" l10n="U" oldref="125">Syntax</paragraph> |