Desktop software can use a number of formulas to determine an address for a named range. Google's not there yet.
Given that I have the address since the formula works in a regular cell.
Is there a way I can use it for a named range without indirect?
Say cell formula in A1 results as "C16" and cell formula in A2 results as "C150". I need to take that and make a named range =C16:C150. Resulting in a dynamic range as A1 and A2 change. The mentioned formula is just a complex INDEX(MATCH wrapped in a CELL("ADDRESS"..)