I have an excel sheet with a linest formula that goes like this:
=LINEST(INDIRECT(T61),INDIRECT(U61),FALSE)
The formula in:
T61 is ="Regress" &A61&B61 & "YVars"
U61 is ="Regress" &A61&B61 & "YVars"

A61 has the value something like "ABCD101" and that is the first row, first column of the table where the data exists.
What does "Regress" mean in this context? How does the value in T61 and INDIRECT function on this value translate into an array of y values required by LINEST function?