I want to use a formula for a row using a defined name of an array, but the name doesn't exist and isn't known yet. Is it possible to refer to the defined array by referencing a cell with the defined name in it?
For example, the array would be created and named ABCArray and entered into cell B1. And the formula I want to have ready in the row is VLOOKUP(A2,B1,1,FALSE). But it won't let me reference a cell to provide a name, I have to put the name directly into the formula: VLOOKUP(A2,ABCArray,1,FALSE).
Is there a way around this?
Bookmarks