For example,
In the data I have A1 = 0.5 B1 = 0.6 C1=1

In the array, it needs to look up the values A1, B1, and C1.
But the array only has the following values.
0
0.5
1

If it looks up 0.6, it will return the value found in the 0.5 field. I need it to return the value in the 1 field.

The other part of the problem is that the various arrays don't all contain the same numbers, so one array might well contain array
0
0.5
1
but another array might only include
5
10
20
(in which case the above 3 examples should all show the value for 5, and not N/A)