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
- 565 reads

Recent comments
3 hours 16 min ago
10 hours 7 min ago
9 hours 22 min ago
12 hours 26 min ago
22 hours 45 min ago
1 day 2 hours ago
1 day 2 hours ago
1 day 8 hours ago
1 day 9 hours ago
2 days 14 min ago