Suppose I have a vector of cells A1:A5, each with a string that is the address of another cell.
What I want to do is to have a function that returns an array of values from these reference cells. See Example - I want the formula to return 15 (it returns 1).
In production settings, this vector is much longer (about 2000 lines).
To solve the problem, this is an INDIRECT () function with array support.
(I understand that I could push Excel beyond) ...
My further thoughts on this topic:
INDIRECT() , "INDIRECTARR()" (.. ) Excel, .