I have set up a table with 5 columns such as below;
<tbody>
</tbody>
I would like to input the diameter and the wall thickness to achieve an output of the corresponding tolerance in the 5th column.
Ex. If diameter = 90.1 & Wall thickness = 1.2 THEN Tol = 0.640
Can you provide a VLOOKUP or correct formula to do so?
Thanks Glen
DIAMETER | WALL | |||
Low Ø | HI Ø | LO | HI | OD ± |
0.000 | 12.740 | 0.510 | 1.240 | 0.100 |
12.700 | 25.400 | 0.510 | 1.650 | 0.130 |
12.700 | 25.400 | 1.660 | 3.400 | 0.250 |
25.400 | 38.100 | 0.640 | 1.650 | 0.200 |
25.400 | 38.100 | 1.660 | 3.400 | 0.250 |
38.100 | 50.800 | 0.640 | 1.240 | 0.250 |
38.100 | 50.800 | 1.250 | 2.110 | 0.280 |
50.800 | 63.500 | 2.120 | 3.780 | 0.300 |
50.800 | 63.500 | 0.810 | 1.650 | 0.300 |
50.800 | 63.500 | 1.660 | 2.770 | 0.330 |
63.500 | 88.900 | 2.780 | 4.190 | 0.360 |
63.500 | 88.900 | 0.810 | 4.190 | 0.510 |
88.900 | 127.000 | 4.190 | 10.000 | 0.510 |
88.900 | 127.000 | 0.890 | 4.190 | 0.640 |
127.000 | 190.500 | 1.240 | 6.350 | 0.640 |
127.000 | 190.500 | 6.360 | 10.000 | 0.760 |
<tbody>
</tbody>
I would like to input the diameter and the wall thickness to achieve an output of the corresponding tolerance in the 5th column.
Ex. If diameter = 90.1 & Wall thickness = 1.2 THEN Tol = 0.640
Can you provide a VLOOKUP or correct formula to do so?
Thanks Glen