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)

Please post a sample sheet with some data and expected results. Thx

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Here is a sample file...

NOTE: I know the results in the sample file can be achieved by vlookup or index+match combo or any other method and that is not the issue, all I want to know is how do I change the array elements while I'm filling down the cells in cells B16 to B18 as I mentioned in my question (see #1).

Attached Files

123.xlsx (10.8 KB, 18 views)