Spreadsheet: 493793d1481888725-returning-multiple-results-closest-match-not-exact-from-a-table-using-multiple-criteria-multipleselection
Sheet: Submersible_Database

Power (kW) | [NAME] (m) | [NAME]. Head (m)2 | BEP Head (m)3 | BEP Flow (m3/h) | Min. Flow (m3/h) | [NAME]. Flow (m3/h) | [NAME] | Helper | Model sequence
0.37 | 34 | 47 | 39.39 | 1.74 | 0.4 | 2.7 | PN5-GP002-09-SW4
0.37 | 40 | 70 | 55.71 | 0.94 | 0.2 | 1.5 | PN5-GP001-14-SW4
1.5 | 145 | 266 | 205.8 | 0.94 | 0.2 | 1.5 | PN22-GP001-57-SW4
1.5 | 57 | 92 | 73.67 | 4.53 | 0.7 | 6.7 | PN30-GP005-17-SW4
2.2 | 185 | 252 | 212.3 | 1.74 | 0.4 | 2.7 | PN30-GP002-48-SW4
2.2 | 135 | 184 | 154 | 2.75 | 0.8 | 4.3 | PN30-GP003-33-SW4
2.2 | 84 | 137 | 109 | 4.53 | 0.7 | 6.7 | PN30-GP005-25-SW4
2.2 | 33 | 73 | 57.41 | 8.64 | 3 | 11.4 | PN30-GP008-15-SW4
2.2 | 27 | 42 | 36.01 | 12.41 | 4 | 18.8 | PN30[NAME]
4 | 344 | 469 | 394.6 | 1.74 | 0.4 | 2.7 | PN55-GP002-90-SW4
4 | 258 | 336 | 287.6 | 2.75 | 0.8 | 4.3 | PN55-GP003-60-SW4
4 | 148 | 239 | 191 | 4.53 | 0.7 | 6.7 | PN55-GP005-44-SW4
4 | 36 | 71 | 58.93 | 18.27 | 12.3 | 26.1 | PN55-GJ017-08-SW4
4 | 27 | 40 | 32.5 | 27.03 | 7.9 | 39 | PN55-GP030-04-SW4
4 | 18 | 32 | 21.33 | 44.86 | 10 | 60 | PN55-GP046 -03-C-SW4
5.5 | 45 | 89 | 73.66 | 18.27 | 12.3 | 26.1 | PN75-GJ017-10-SW4
5.5 | 35 | 51 | 41.62 | 27.03 | 7.9 | 39 | PN75-GP030-05-SW4
5.5 | 16 | 35 | 22.72 | 57.29 | 20 | 78 | PN75-GP060-03-SW4
5.5 | 12.84 | 18 | 12.84 | 85.41 | 20 | 123.8 | PN75-GP095-01-XW6
7.5 | 186 | 236 | 186.7 | 8.64 | 3 | 11.4 | PN110-GP008-50-XW6
7.5 | 94 | 148 | 125.6 | 12.41 | 4 | 18.8 | PN110-GP014-25-XW6
7.5 | 63 | 124 | 103.1 | 18.27 | 12.3 | 26.1 | PN110-GJ017-14-XW6
7.5 | 55 | 81 | 65.34 | 27.03 | 7.9 | 39 | PN110-GP030-08-XW6
7.5 | 22 | 47 | 30.71 | 57.29 | 20 | 78 | PN110-GP060-04-XW6
11 | 189 | 318 | 270.6 | 7.26 | 3.4 | 12 | PN150-GJ006-38-XW6
11 |  |  | 115.1 | 21.52 | 12.9 | 29.1 | PN150-GJ020-15-XW6
11 |  |  | 105.5 | 27.03 | 7.9 | 39 | PN150-GP030-13-XW6
11 | 34 | 71 | 47.32 | 57.29 | 20 | 78 | PN150-GP060-06-XW6
11 |  |  | 35.84 | 75.91 | 20 | 100 | PN150-GP077-03-XW6
11 | 56 | 91 | 64.4 | 44.86 | 10 | 60 | PN150-GP046-08-C-XW6
11 | 31 | 47 | 32.78 | 85.41 | 20 | 123.8 | PN150-GP095-03-B-XW6
11 |  |  | 20.26 | 117.4 | 20 | 162.5 | PN110-GP125-01-XW6
15 |  |  | 265.3 | 10.29 | 5.6 | 15.9 | PN150-GJ009-40-XW6
15 | 118 | 171 | 139.2 | 27.03 | 7.9 | 39 | PN185-GP030-17-XW6
15 |  |  | 68.14 | 57.29 | 20 | 78 | PN185-GP060-09-B-XW6
15 | 44 | 65 | 46.12 | 85.41 | 20 | 123.8 | PN185-GP095-04-B-XW8
15 |  |  | 12.74 | 219.5 | 40 | 280 | PN150-GP215-01-A-XW6
18.5 | 147 | 214 | 173.9 | 27.03 | 7.9 | 39 | PN220-GP030-21-XW6
18.5 |  |  | 81.19 | 57.29 | 20 | 78 | PN220-GP060-10-XW6
18.5 | 54 | 80 | 56.62 | 85.41 | 20 | 123.8 | PN220-GP095-05-AB-XW6
18.5 |  |  | 25.14 | 164.7 | 20 | 217 | PN185-GP160-02-AA-XW6
18.5 |  |  | 21.25 | 219.5 | 40 | 280 | PN185-GP215-01-XW6
30 |  |  | 476.6 | 14.57 | 4 | 22.1 | PN370-GP017-53-XW6
30 | 155 | 241 | 175.4 | 44.86 | 10 | 60 | PN370-GP046-20-XW6
30 | 87 | 128 | 90.84 | 85.41 | 20 | 123.8 | PN370-GP095-07-XW6
30 |  |  | 30.48 | 219.5 | 40 | 280 | PN300-GP215-02-AA-XW6
37 |  |  | 40.26 | 219.5 | 40 | 280 | PN370-GP215-02-A-XW6
37 | 301 | 432 | 356.1 | 27.03 | 7.9 | 39 | PN450-GP030-43-XW6
37 | 188 | 289 | 212.4 | 44.86 | 10 | 60 | PN450-GP046-24-XW6
45 | 360 | 504 | 420.5 | 27.03 | 7.9 | 39 | PN550-GP030-49-XW8
45 |  |  | 48.4 | 219.5 | 40 | 280 | PN450-GP215-02-XW8
45 | 141 | 274 | 187.8 | 57.29 | 20 | 78 | PN550-GP060-22-XW8
55 |  |  | 66.12 | 219.5 | 40 | 280 | PN750-GP215-03-A-XW8
66 |  |  | 73.79 | 219.5 | 40 | 280 | PN750-GP215-03-XW8
66 | 305 | 457 | 342.2 | 44.86 | 10 | 60 | PN750-GP046-37-XW8
66 |  |  | 228.6 | 75.91 | 20 | 100 | PN750-GP077-18-XW8
66 | 185 | 259 | 192.2 | 85.41 | 20 | 123.8 | PN750-GP095-14-XW8
66 |  |  | 144.7 | 117.4 | 20 | 162.5 | PN750-GP125-07-A-HW1