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?

Attached Images

123.png (9.5 KB, 24 views)