I tried the example in the documentation page of the INDEX function at
https://wiki.documentfoundation.org/Documentation/Calc_Functions/INDEX
in the case
=INDEX(B2:B4; 3)
and I get a #VALUE! error, which, according to the documentation should be issued
“if any of Row, Column, or Range is non-numeric”
but it’s not. What else could it be?
I wrote the table exactly as shown in the example.
Ops! I was actually setting B2:D4 in the reference. Thanks.
what’s in B4 ?
Just like in the example: “TRUE”
Please upload your ODF type sample file here.
The earlier questio was solved, I was just using an incorrect setting for the Reference value. However, I have a new question now. If I use the formula
{ =INDEX(B2:D4; 2; 0) }
with the same example I do not get an array spread through three cells, as the documentation says, but just the text of the formula.
I tried entering it with the combination Ctrl+Shif+Enter as the doc says, but nothing happens. What am I doing wrong?
INDEX Function example.ods (10.8 KB)
I am uploading the file.
You are asking a new question as a comment to an old question, for one. Also you are misinterpreting the “spread triggering” and/or the entry procedure for spreadsheet array formulas.
Ask again as a new question. You will be answered.
-
you should NEVER put {}curly-braces manually around formulas, the latter is implicitly triggered by ctrl+shift+enter or the [x]arrayoption in the formula wizard
-
INDEX starts counting with 1 but not 0, so your :
should be:
=INDEX(B2:D4; 2; 1)
and as it returns a single entry … it dosn’t need ctrl+shift+enter
Thank you, it worked with the 0 too, returning an array instead of a single number, as is stated in the documentation.
Thanks again and sorry if I did not open a new topic.
IMHO would prefer =INDEX(B2:D4 ; 2 ) in the latter case
Right! It worked like that too, thanks.