I don't know if this is possible with some sort of lookup function
combination, but maybe somebody has an idea...


I have the following table, gauge ranges shown in the first column,
and across we have width ranges:


A1 B1 C1 D1
1-2 3-4 4-5
A2 .200-.249 1 6 9
A3 .250-.274 3 6 10
A4 .275-.300 5 7 12


I need to create a lookup function where in another sheet I have the
following

Column A Column B
Enter Gauge: .243
Enter Width: 3.5
Result: 6

Where you punch in the gauge and width and it looks it up on the table
according to range. In this case, it knows that .243 is in the first
row, and width 3.5 falls under the C column, so the result is 6.


I need to find some lookup function that finds the result, based on
the input Gauge and Width, when the table is set up in ranges. Is this
possible??