Creating a dynamic array for some formulas
How do I create a dynamic array in a formula which while filling down the items of the array change.
What I want is in cell D20, while in a function like say dget where there is an array field part in the formula, the contents of the array will be C19 and C20 i.e. {"Customer ID";"12D101"}, then when I fill down the formula the contents of the array in cell D21 will be C19 and C21 i.e. {"Customer ID";"12D102"}, then in cell D22 will be C19 and C22 i.e. {"Customer ID";"12D103"} and so on..
How can I do this?
|