Represent More Than One Value In Either A Variable Or Single Index Position Of An Array?

I have a very large number of tables with data in the following format:

A X Y Z
1 0-2 0-13 0-1
2 3-5 14 2-4
3 6-9 15-16 5-10

In other words, there is a variable (call it A) with a single value that corresponds to a range of values in the other variables (call them X, Y, and Z).My program needs to accept user text input of values of X, Y, Z, etc. and then match each to the corresponding value of A.Example: User enters 4 in the X text box; program determines that if X=4, A=2.Again, we're talking about tables and tables of data in this format. Unaware of a better method, I have been using arrays.

Example:

Dim a() as double = {1,1,1,2,2,2,3,3,3,3...}
Dim x() as double = {0,1,2,3,4,5,6,7,8,9,10...}

Note how I had to artificially deal with variable A so that the index of each score corresponds to the index of the matching X variable.It is this modification of the variables that is taking forever. There has to be a better way! Hypothetically, what I need is the ability to do something like this:

Dim a() as double = {1,2,3,4...}
dim x() as double = {0 to 2, 3 to 5, 6 to 9...}

Is there a way to represent a range of values at a single index of an array, such as my hypothetical example above? This would save me hours of re-shaping the data to make the arrays work.