Forum Discussion
Using Indirect() function with a dynamically set named range
Hello, [Edit Apr 27] - Example attached. Let's say that in Sheet1 I have a local named range is that defined as Name: Dynamic_Array Refers to: =$A$1:INDEX($A$1:$E$1,3) Range A1:E1 has num...
Sorry that I was so careless as to overlook the workbook, and then request it!
I cannot find any satisfactory way of returning dynamic arrays using INDIRECT. I can use CHOOSE to select a specific sheet
= CHOOSE(XMATCH(factory,factory.list),
Factory1!product.data,
Factory2!product.data,
Factory3!product.data)but its use made little sense where you wanted to sum over each factory.
Maybe, some time in the future, I will be able to demonstrate a Lambda function to return production volumes etc.
= VOLUMEλ(factory, product, month)and maybe, even to demonstrate new functionality to sum production over a list of factories.