We're trying to find a pipe size in a row, that corresponds to a value of flow within a table (which is found by matching an input flow with a table), see example below. For example, a value for kvs and DN are input by user, the user then inputs desired flow rate which needs to match approximately the closest value in the table. This information is used to find the pressure by selecting the appropriate pressure value where kvs AND dn AND Flow rate match. So, for example, if the user selects kvs = 31, dn = 50, and flow rate = 4.3. Excel automatically selects pressure = 0.03 (4.3 is rounded up to 4.4). I know it's a bit complicated but we need help! Thanks
<tbody>
</tbody><colgroup><col span="2"><col span="4"><col></colgroup>
Pressure | 0.01 | 0.02 | 0.03 | 0.04 | ||
kvs | dn | |||||
31 | 50 | 3.0 | 3.7 | 4.4 | 5.0 | |
40 | 50 | 4.0 | 4.9 | 5.8 | 6.4 | |
49 | 65 | 4.8 | 5.9 | 7.0 | 7.6 | |
63 | 65 | 6.4 | 7.7 | 9.0 | 10.0 | |
78 | 80 | 7.6 | 9.1 | 10.5 | 12.0 | |
100 | 80 | 10.0 | 12.5 | 15.0 | 16.5 |
<tbody>
</tbody><colgroup><col span="2"><col span="4"><col></colgroup>