TheKid0401's blog
VLOOKUP with Variable Label to Initialize
Submitted by TheKid0401 on 16 January, 2012 - 07:52I have an composite array of data in my Worksheet. I am using a Vlookup function to process the array for various algorithms which require data from the array. The composite array is horizontally divided by three rows of irrelevant data ("IR Data") into two arrays (upper and lower) which requires that the Vlookup function be initialized differently in the upper and lower array; i.e., the starting row of the lower array (below the IR Data) changes with varying output that populates the array.
»
- 4 comments
- Read more
- 4860 reads
Recent comments
5 years 42 weeks ago
6 years 28 weeks ago
6 years 40 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 49 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago