Spreadsheet: 330258d1404655318-multiple-hlookups-nostrum-oeldere-330229d1404639986-multiple-hlookups-flow-rate-help-sheet
Sheet: Sheet1

 | Circuit | Circuit Description | Flow Rate | [NAME] | Flow Pipework length | Fittings Allowance | Total  length | Pressure Loss | Total Pressure Loss | Velocity |  |  |  |  | Velocity | [NAME] ([NAME]) kg/s |  |  |  |  |  | Pressure Loss |  | Velocity | [NAME] ([NAME]) kg/s |  |  |  |  | Pressure Loss
 |  |  | (kg/s) |  | ([NAME]) | (+50%) | (Equivelant) | ([NAME] [NAME]) | ([NAME]) | O.K? |  |  |  |  | m/s | 8 | 10 | 15 | 22 | 28 | 35 | [NAME] |  | m/s | 42 | 54 | 67 | 76 | 108 | [NAME]
 |  |  | 0.0212 | 8 | 5.33 |  |  |  |  |  |  |  |  |  |  |  | 0.0108 | 0.038 | 0.109 | 0.227 | 0.4 | 0.008 |  |  | 0.169 | 0.347 | 0.626 | 0.89 | 2.353 | 0.0007
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0114 | 0.04 | 0.117 | 0.235 | 0.424 | 0.009 |  |  | 0.183 | 0.374 | 0.676 | 0.96 | 2.532 | 0.0008
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0064 | 0.0122 | 0.042 | 0.124 | 0.25 | 0.448 | 0.01 |  |  | 0.196 | 0.399 | 0.722 | 1.026 | 2.709 | 0.0009
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0067 | 0.0129 | 0.044 | 0.131 | 0.263 | 0.475 | 0.011 |  |  | 0.208 | 0.424 | 0.767 | 1.088 | 2.869 | 0.001
 |  |  |  |  |  |  |  | 0.082 |  |  |  |  |  |  |  | 0.0071 | 0.0135 | 0.047 | 0.137 | 0.277 | 0.499 | 0.012 |  |  | 0.23 | 0.47 | 0.848 | 1.206 | 3.176 | 0.0012
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0074 | 0.0141 | 0.049 | 0.144 | 0.289 | 0.523 | 0.013 |  |  | 0.261 | 0.592 | 0.962 | 1.365 | 3.599 | 0.0015
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0077 | 0.0147 | 0.052 | 0.15 | 0.302 | 0.543 | 0.014 |  |  | 0.289 | 0.645 | 1.065 | 1.517 | 3.979 | 0.0018
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0081 | 0.0154 | 0.054 | 0.156 | 0.314 | 0.564 | 0.015 |  |  | 0.316 | 0.695 | 1.159 | 1.646 | 4.337 | 0.0021
 |  | Sorry if I did not explain it well. |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0084 | 0.0159 | 0.056 | 0.161 | 0.325 | 0.594 | 0.016 |  |  | 0.341 | 0.743 | 1.253 | 1.776 | 4.666 | 0.0024
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0086 | 0.0165 | 0.058 | 0.167 | 0.336 | 0.604 | 0.017 |  | 0.3 m/s | 0.364 | 0.788 | 1.341 | 1.899 | 4.984 | 0.0027
 |  | The values have been entered into row 4 already, although for some reason the pipe size is missing from the file. |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0089 | 0.0171 | 0.06 | 0.172 | 0.348 | 0.623 | 0.018 |  |  | 0.387 | 0.832 | 1.424 | 2.009 | 5.282 | 0.003
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0092 | 0.0176 | 0.061 | 0.178 | 0.359 | 0.645 | 0.019 |  |  | 0.408 | 0.887 | 1.497 | 2.125 | 5.567 | 0.0033
 |  | So [NAME] is a pre defined value from another sheet (very big spreadsheet so have not included) and will be either 8,10,15,22,28,35,42,54,67,76 or 108. |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0095 | 0.0182 | 0.063 | 0.183 | 0.369 | 0.669 | 0.02 |  |  | 0.436 | 0.927 | 1.596 | 2.261 | 5.933 | 0.0037
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0098 | 0.0185 | 0.065 | 0.188 | 0.38 | 0.686 | 0.021 |  |  | 0.455 | 0.965 | 1.671 | 2.362 | 6.192 | 0.004
 |  | This value needs to be referred to in the tables (Q3-V3) & (Z3 - AD3) |  |  |  |  |  |  |  |  |  |  |  |  | 0.3 m/s | 0.0101 | 0.0192 | 0.067 | 0.193 | 0.39 | 0.704 | 0.022 |  |  | 0.474 | 1.013 | 1.733 | 2.459 | 6.451 | 0.0043
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0106 | 0.0203 | 0.07 | 0.203 | 0.408 | 0.735 | 0.024 |  |  | 0.499 | 1.048 | 1.822 | 2.585 | 6.772 | 0.0047
 |  | So for example a pipe size of 8 would relate to column Q. |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0111 | 0.0212 | 0.073 | 0.212 | 0.428 | 0.773 | 0.026 |  |  | 0.516 | 1.084 | 1.887 | 2.673 | 7.007 | 0.005
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0116 | 0.0221 | 0.076 | 0.221 | 0.446 | 0.805 | 0.028 |  |  | 0.533 | 1.131 | 1.95 | 2.763 | 7.238 | 0.0053
 |  | Then using the value of D4 (also pre defined from another sheet) which in this case is 0.0212 I need to use [NAME] to find this or the next largest value from column Q which in this case is Q48 (0.0215) |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.012 | 0.023 | 0.08 | 0.23 | 0.464 | 0.838 | 0.03 |  |  | 0.555 | 1.166 | 2.028 | 2.875 | 7.535 | 0.0057
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0125 | 0.0238 | 0.082 | 0.238 | 0.482 | 0.869 | 0.032 |  |  | 0.572 | 1.194 | 2.087 | 2.958 | 7.747 | 0.006
 |  | I then need to apply the data in the relevent column in W (so in this case [NAME]) and input this into cell I4. |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0129 | 0.0245 | 0.085 | 0.247 | 0.5 | 0.898 | 0.034 |  |  | 0.587 | 1.238 | 2.146 | 3.04 | 7.958 | 0.0063
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0113 | 0.0253 | 0.088 | 0.255 | 0.518 | 0.925 | 0.036 |  | 0.5 m/s | 0.608 | 1.269 | 2.221 | 3.147 | 8.238 | 0.0067
 |  | So using E (pipe size) determine which column the data is in, then using the value of D (flow rate) determine pressure loss created in the far right column of the table. |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0138 | 0.0261 | 0.091 | 0.263 | 0.533 | 0.952 | 0.038 |  |  | 0.623 | 1.299 | 2.273 | 3.222 | 8.438 | 0.007
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0142 | 0.0268 | 0.094 | 0.27 | 0.548 | 0.982 | 0.04 |  |  | 0.638 | 1.336 | 2.332 | 3.298 | 8.632 | 0.0073
 |  | To make matters more complicated, the data is in 2 separate tables depending on pipe size. |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0146 | 0.0276 | 0.096 | 0.278 | 0.564 | 1.01 | 0.042 |  |  | 0.657 | 1.368 | 2.398 | 3.394 | 8.893 | 0.0077
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.015 | 0.0283 | 0.099 | 0.286 | 0.578 | 1.035 | 0.044 |  |  | 0.72 | 1.391 | 2.449 | 3.473 | 9.081 | 0.008
 |  | I would really appreciate some help! |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0154 | 0.029 | 0.101 | 0.293 | 0.592 | 1.048 | 0.046 |  |  | 0.686 | 1.433 | 2.502 | 3.544 | 9.264 | 0.0083
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0158 | 0.0298 | 0.104 | 0.3 | 0.608 | 1.075 | 0.048 |  |  | 0.704 | 1.459 | 2.565 | 3.638 | 9.509 | 0.0087
 |  | Thanks in advance |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0162 | 0.0305 | 0.106 | 0.307 | 0.622 | 1.1 | 0.05 |  |  | 0.717 | 1.49 | 2.612 | 3.705 | 9.686 | 0.009
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0167 | 0.0312 | 0.108 | 0.314 | 0.637 | 1.123 | 0.052 |  |  | 0.731 | 1.521 | 2.659 | 3.769 | 9.862 | 0.0093
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.017 | 0.032 | 0.111 | 0.321 | 0.651 | 1.15 | 0.054 |  |  | 0.749 | 1.545 | 2.722 | 3.863 | 10.105 | 0.0097
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 m/s | 0.0173 | 0.0326 | 0.113 | 0.328 | 0.665 | 1.178 | 0.056 |  |  | 0.761 | 1.71 | 2.769 | 3.924 | 10.246 | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0177 | 0.0332 | 0.115 | 0.334 | 0.678 | 1.194 | 0.058 |  |  | 0.842 | 1.86 | 3.065 | 4.341 | 11.272 | 0.012
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018 | 0.0339 | 0.117 | 0.34 | 0.691 | 1.215 | 0.06 |  |  | 0.918 | 2.007 | 3.342 | 4.727 | 12.365 | 0.014
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0184 | 0.0345 | 0.12 | 0.247 | 0.705 | 1.235 | 0.062 |  |  | 0.989 | 2.137 | 3.591 | 5.084 | 13.261 | 0.016
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0187 | 0.0351 | 0.122 | 0.353 | 0.718 | 1.253 | 0.064 |  |  | 1.058 | 2.265 | 3.837 | 5.429 | 14.144 | 0.018
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.019 | 0.0358 | 0.124 | 0.359 | 0.724 | 1.272 | 0.066 |  |  | 1.118 | 2.392 | 4.066 | 5.748 | 15.026 | 0.02
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0193 | 0.0364 | 0.126 | 9.364 | 0.736 |  | 0.068 |  |  | 1.177 | 2.512 | 4.283 | 6.054 |  | 0.022
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0196 | 0.037 | 0.128 | 0.37 | 0.75 |  | 0.07 |  | 1.0 m / s | 1.236 | 2.622 | 4.491 | 6.351 |  | 0.024
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02 | 0.0377 | 0.13 | 0.375 | 0.762 |  | 0.072 |  |  | 1.295 | 2.73 | 4.697 | 6.645 |  | 0.026
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0203 | 0.0382 | 0.132 | 0.381 | 0.774 |  | 0.074 |  |  | 1.354 | 2.838 | 4.896 | 6.917 |  | 0.028
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0206 | 0.0388 | 0.134 | 0.386 | 0.785 |  | 0.076 |  |  | 1.406 | 2.939 | 5.085 |  |  | 0.03
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0208 | 0.0394 | 0.136 | 0.391 | 0.797 |  | 0.078 |  |  | 1.544 | 3.044 | 5.264 |  |  | 0.032
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0211 | 0.04 | 0.138 | 0.397 | 0.808 |  | 0.08 |  |  | 1.504 | 3.139 |  |  |  | 0.034
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0215 | 0.0406 | 0.14 | 0.402 | 0.8129 |  | 0.082 |  |  | 1.553 | 3.233 |  |  |  | 0.036
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0217 | 0.0411 | 0.142 | 0.407 | 0.83 |  | 0.084 |  |  | 1.602 | 3.325 |  |  |  | 0.038
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.022 | 0.0417 | 0.144 | 0.412 | 0.841 |  | 0.086 |  |  | 1.645 | 3.414 |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0223 | 0.0423 | 0.146 | 0.417 | 0.851 |  | 0.088 |  |  | 1.69 |  |  |  |  | 0.042
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0226 | 0.0429 | 0.148 | 0.422 | 0.862 |  | 0.09 |  |  | 1.733 |  |  |  |  | 0.044
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0229 | 0.0433 | 0.149 | 0.426 | 0.872 |  | 0.092 |  | 1.5 m / s | 1.778 |  |  |  |  | 0.046
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0231 | 0.0439 | 0.151 | 0.431 |  |  | 0.094 |  |  | 1.821 |  |  |  |  | 0.048
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0234 | 0.0445 | 0.153 | 0.435 |  |  | 0.096 |  |  | 1.861 |  |  |  |  | 0.05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0237 | 0.045 | 0.155 | 0.44 |  |  | 0.098
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.024 | 0.0455 | 0.156 | 0.445 |  |  | 0.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0243 | 0.046 | 0.158 | 0.449 |  |  | 0.102
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0245 | 0.0465 | 0.16 | 0.453 |  |  | 0.104
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0247 | 0.0469 | 0.162 | 0.458 |  |  | 0.106
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.025 | 0.0474 | 0.164 | 0.462 |  |  | 0.108
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0253 | 0.0479 | 0.165 | 0.466 |  |  | 0.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0256 | 0.0484 | 0.167 | 0.471 |  |  | 0.112
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0258 | 0.0488 | 0.169 | 0.475 |  |  | 0.114
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0261 | 0.0493 | 0.17 | 0.479 |  |  | 0.116
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0264 | 0.0498 | 0.172 |  |  |  | 0.118
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0266 | 0.0502 | 0.174 |  |  |  | 0.12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0279 | 0.0523 | 0.181 |  |  |  | 0.13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0291 | 0.0548 | 0.189 |  |  |  | 0.14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0302 | 0.0568 | 0.197 |  |  |  | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0314 | 0.0588 | 0.204 |  |  |  | 0.16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0326 | 0.0608 | 0.211 |  |  |  | 0.17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0336 | 0.0628 |  |  |  |  | 0.18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0347 | 0.0648 |  |  |  |  | 0.19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.0 m/ s | 0.0357 | 0.0668 |  |  |  |  | 0.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.5 m / s