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?

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

Nick's picture

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.