Hi,
In an excel file we have various named ranges.
Ideally in a column we could reference these as arrays in an INDEX formula as a name so the array would change depending on cells in a column, just like how the row or column reference numbers can change.
Do you know if this is possible as...