I have an array of values that I need to lookup a value in. The interesting
part is that the lookup values have to search citeria that are between
min-max values. To make it more interesting there are multiple criteria in
the row lookup. Basically I have a list of rectangular dimensions, length,
width and thickness. that are used to lookup a yield percentage. The
thickness and width dimensions provide the looup array to find a row by
finding where the lookup value fits in the min-max dimensions. This is also
true about the column criteria, each column must be found by determining
finding the correct range range between min-max values. Another interesting
part of this is that there are repetitive values in both the thickness and
width lookup arrays although they are in different combinations. I paste an
example of this here to illustrate.

Length
Thickness Width 306 801 1800 min
Min Max Min Max 800 1799 2399 max
1 19 1 39 50.0% 44.6% 39.9%
1 19 40 93 26.3% 23.1% 20.4%
1 19 94 102 26.0% 22.9% 20.2%
1 19 103 199 25.7% 22.7% 20.0%
1 19 200 210 25.4% 22.4% 19.8%
1 19 211 299 25.2% 22.2% 19.6%
20 39 40 93 17.3% 15.5% 13.4%
20 39 94 102 17.1% 15.3% 13.3%
20 39 103 199 17.0% 15.1% 13.2%

I have been trying to do this with an Index/match combination but I can''t
get the match functions to cooperate and work together to find the multiple
criteria.
Any help is much appreciated.
Thanks,
RDW