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).
|