VLOOKUP with Variable Label to Initialize
I 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. Is there any straight-forward way to assign a Label to each of the start row (the row which initializes the Vlookup syntax) for the upper and lower array based on an identification protocol and then use the Label as a variable for the Vlookup function. I am trying to not make this an exercise in VB programming. Any ideas out there?
- TheKid0401's blog
- Login or register to post comments
- 4834 reads
pls add as simple an example
pls add as simple an example file as you can
show:
- inputs
Required outputs
tks
VLOOKUP with Variable Label to Initialize
I will follow-up on your reply with an example. You may want to provide an E-mail for a relevant screen shot as well as the example excel file. Thank you for the thoughtfulness of taking a look. TK
simply add the files to your
simply add the files to your post
- log in and edit the post
VLOOKUP with Variable Label to Initialize
Forgive the "newbie" perspective; however, I am not familiar with adding files to the Blog ... illumination would be great and I am sorry for the education request.