#1
|
|||
|
|||
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? |
#2
|
||||
|
||||
Please post a sample sheet with some data and expected results. Thx
__________________
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 |
#3
|
|||
|
|||
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). |
Tags |
array |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
creating a named row for dynamic addressing | trevorc | Excel Programming | 8 | 07-08-2018 03:21 AM |
Creating Dynamic Ranking Tables | ssol2016 | Excel | 1 | 10-27-2016 08:47 AM |
Creating a dynamic summary sheet | FenelonPaul | Excel | 5 | 09-23-2015 07:11 AM |
Help Creating A Dynamic Footer | Mikemo | Word | 3 | 02-05-2013 11:58 AM |
Creating Formulas in a Word Form | pittz2002 | Word | 0 | 08-25-2009 08:36 AM |