Excel inserts curly brackets in the beginning and close with the formula for you. For more info on array formulas, see Rules and examples of array formulation. in cell A2 as the result, so it isn't really apparent that INDEX is returning a reference. On the other hand, this is https://www.tumblr.com/kosaniguana/757918794809262080