, that's provided as A variety of cells or an array continuous. The syntax with the array method of INDEX is: in cell A2 as The end result, so it's actually not apparent that INDEX is returning a reference. Nonetheless, this can be a beneficial characteristic in formulas such as https://www.kosaniguana.tumblr.com/