summaryrefslogtreecommitdiff
path: root/source
diff options
context:
space:
mode:
authorMike Kaganski <mike.kaganski@collabora.com>2019-02-12 11:44:07 +0100
committerOlivier Hallot <olivier.hallot@libreoffice.org>2019-03-16 14:48:11 +0100
commit925fcf8140657eeebf3d233cbe59323d856fe647 (patch)
tree24e76b847a49ed9f688254d7eb0a7048cff01cfc /source
parent79599a40c6990b8649f88689d4761bbe6529388e (diff)
VLOOKUP's Array parameter may take 1-column arrays
It only depends on Index value; so for Index=1, 1-column array input is OK. Change-Id: I80d5655ffcb9374fcdce570f56606d5ff594002c Reviewed-on: https://gerrit.libreoffice.org/67716 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source')
-rw-r--r--source/text/scalc/01/04060109.xhp2
1 files changed, 1 insertions, 1 deletions
diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp
index 93fcb7dbbe..2a5d6d45bb 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -279,7 +279,7 @@
<paragraph xml-lang="en-US" id="par_id3149289" role="paragraph">
<emph>SearchCriterion</emph> is the value searched for in the first column of the array.</paragraph>
<paragraph xml-lang="en-US" id="par_id3153884" role="paragraph">
- <emph>Array</emph> is the reference, which is to comprise at least two columns.</paragraph>
+ <emph>Array</emph> is the reference, which is to comprise at least as many columns as the number passed in Index argument.</paragraph>
<paragraph xml-lang="en-US" id="par_id3156005" role="paragraph">
<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 xml-lang="en-US" id="par_id3151208" role="paragraph">