Excel inserts curly brackets firstly and conclusion with the formula to suit your needs. For more info on array formulation, see Tips and examples of array formulation. in cell A2 as the result, so it's not obvious that INDEX is returning a reference. However, this can be a beneficial feature https://www.tumblr.com/ruyadabuluaslim/757910392592826368