Referring to the below screenshot, I have a question about Index Function in MS Excel. Can INDEX actually return an Array? e.g. I have numbers in cells A1:A5 as seen in the screenshot. In Cells C1:C5 I put an Array Formula
and it successfully returns numbers from A1:A5, indicating that INDEX can return an array in a set of cells.
However when I use a formula like this one
I was expecting return value of 15 but I get only the first element of the array i.e. 1.
Is this how it is? Can INDEX return an Array that can be used in other Array based formulas?