|
|
#3
01-27-2019, 05:10 AM
|
|||
|
|||
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 |
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 7 32bit 
Office 2010
Threaded Mode