Spreadsheet: 870566d1717063851-multi-variable-lookup-flow-work-sheet-jt
Sheet: Sheet1

Model | gpm | 30 | 50 | 70 | 90 | 110 |  | Model | gpm | Temperature | Pressure
9 | 1.5 | 1.9 | 1.8 | 1.7 | 1.6 | 1.5 |  | 9 | 1.5 | 30 | 1.9 |  | End goal
9 | 2 | 3.5 | 3.4 | 3.2 | 3.1 | 3 |  | 9 | 2 | 30 | 3.5
9 | 3 | 6.9 | 6.5 | 6.3 | 6 | 5.7 |  | 9 | 3 | 30 | 6.9 |  |  | Input |  |  | Output
9 | 4 | 12 | 11.4 | 11 | 10.8 | 10.5 |  | 9 | 4 | 30 | 12 |  | Model | 24 |  | GPM
12 | 1.5 | 0.3 | 0.3 | 0.3 | 0.3 | 0.3 |  | 9 | 1.5 | 50 | 1.8 |  | Temperature | 53
12 | 2.5 | 1 | 1 | 1 | 1 | 1 |  | 9 | 2 | 50 | 3.4 |  | Pressure drop | 4.2
12 | 3.5 | 1.7 | 1.7 | 1.7 | 1.6 | 1.6 |  | 9 | 3 | 50 | 6.5
12 | 4.5 | 2.5 | 2.4 | 2.4 | 2.4 | 2.3 |  | 9 | 4 | 50 | 11.4
15 | 2 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 |  | 9 | 1.5 | 70 | 1.7 |  |  |  |  |  | Select Model & Temperature based on O5 & O6 |  |  | gpm | Temperature | Pressure
15 | 3 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 |  | 9 | 2 | 70 | 3.2 |  |  |  |  |  |  |  |  | 3 | 50 | 1.1
15 | 4 | 2.6 | 2.6 | 2.6 | 2.6 | 2.5 |  | 9 | 3 | 70 | 6.3 |  |  |  |  |  |  |  | 24 | 4.5 | 50 | 2
15 | 5 | 3.7 | 3.7 | 3.6 | 3.6 | 3.5 |  | 9 | 4 | 70 | 11 |  |  |  |  |  |  |  | 24 | 6 | 50 | 4
18 | 3 | 1.6 | 1.6 | 1.5 | 1.5 | 1.4 |  | 9 | 1.5 | 90 | 1.6 |  |  |  |  |  |  |  | 24 | 8 | 50 | 4.4
18 | 4 | 2.9 | 2.9 | 2.8 | 2.8 | 2.7 |  | 9 | 2 | 90 | 3.1
18 | 5 | 4.2 | 4.2 | 4.1 | 4 | 3.9 |  | 9 | 3 | 90 | 6 |  |  |  |  |  | Replace formula with x |  | x = FILTER(Table2;(Table2[Model]=O5)*(Table2[Temperature]>=O6-10)*(Table2[Temperature]<=O6))
18 | 6 | 6 | 5.8 | 5.7 | 5.6 | 5.5 |  | 9 | 4 | 90 | 10.8
24 | 3 | 1.1 | 1.1 | 0.9 | 0.8 | 0.6 |  | 9 | 1.5 | 110 | 1.5 |  |  |  |  |  | Compute lower & upper pressure range based on O7 |  | Pressure Range
24 | 4.5 | 2.1 | 2 | 1.8 | 1.7 | 1.5 |  | 9 | 2 | 110 | 3 |  |  |  |  |  |  |  | Lower | Upper
24 | 6 | 4.1 | 4 | 3.8 | 3.7 | 3.5 |  | 9 | 3 | 110 | 5.7
24 | 8 | 4.5 | 4.4 | 4.1 | 3.9 | 3.7 |  | 9 | 4 | 110 | 10.5 |  |  |  |  |  |  |  | False | True
30 | 4 | 1.5 | 1.4 | 1.3 | 1.2 | 1.1 |  | 12 | 1.5 | 30 | 0.3 |  |  |  |  |  |  |  | True | True
30 | 6 | 3 | 2.8 | 2.7 | 2.5 | 2.3 |  | 12 | 2.5 | 30 | 1 |  |  |  |  |  |  |  | True | True
30 | 8 | 5.1 | 4.8 | 4.5 | 4.2 | 3.9 |  | 12 | 3.5 | 30 | 1.7
30 | 10 | 7.7 | 7.2 | 6.8 | 6.3 | 5.8 |  | 12 | 4.5 | 30 | 2.5 |  |  |  |  |  | Replace Q8# with x |  | CHOOSECOLS(x;4)>=XLOOKUP(O7;CHOOSECOLS(x;4);CHOOSECOLS(x;4);"";-1) | CHOOSECOLS(x;4)<=XLOOKUP(O7;CHOOSECOLS(x;4);CHOOSECOLS(x;4);"";1)
36 | 5 | 1 | 1 | 0.9 | 0.8 | 0.8 |  | 12 | 1.5 | 50 | 0.3
36 | 7 | 2.1 | 1.9 | 1.8 | 1.7 | 1.6 |  | 12 | 2.5 | 50 | 1 |  |  |  |  |  | Filtered range |  |  | 6 | 50 | 4
36 | 9 | 3.6 | 3.3 | 3 | 2.8 | 2.6 |  | 12 | 3.5 | 50 | 1.7 |  |  |  |  |  |  |  | 24 | 8 | 50 | 4.4
36 | 12 | 6.3 | 5.9 | 5.5 | 5.1 | 4.8 |  | 12 | 4.5 | 50 | 2.4
42 | 5 | 0.8 | 0.7 | 0.7 | 0.7 | 0.6 |  | 12 | 1.5 | 70 | 0.3
42 | 8 | 2.1 | 2.1 | 1.9 | 1.8 | 1.7 |  | 12 | 2.5 | 70 | 1 |  |  |  |  |  | Replace CHOOSECOLS(x;4) with y |  |  | 6 | 50 | 4
42 | 11 | 4.2 | 4.1 | 3.8 | 3.5 | 3.3 |  | 12 | 3.5 | 70 | 1.7 |  |  |  |  |  |  |  | 24 | 8 | 50 | 4.4
42 | 14 | 7.6 | 6.7 | 6.3 | 5.8 | 5.4 |  | 12 | 4.5 | 70 | 2.4
48 | 6 | 1.1 | 1 | 1 | 0.9 | 0.8 |  | 12 | 1.5 | 90 | 0.3
48 | 9 | 2.3 | 2.1 | 2 | 1.9 | 1.7 |  | 12 | 2.5 | 90 | 1 |  |  |  |  |  | Choose gpm column
48 | 12 | 3.9 | 3.7 | 3.4 | 3.2 | 3 |  | 12 | 3.5 | 90 | 1.6 |  |  |  |  |  |  |  | 8
48 | 16 | 6.7 | 6.3 | 5.9 | 5.5 | 5.1 |  | 12 | 4.5 | 90 | 2.4
60 | 9 | 2.4 | 2.2 | 2.1 | 2 | 1.8 |  | 12 | 1.5 | 110 | 0.3
60 | 12 | 3.9 | 3.6 | 3.4 | 3.2 | 2.9 |  | 12 | 2.5 | 110 | 1 |  |  |  |  |  | Average
60 | 15 | 5.7 | 5.3 | 5 | 4.7 | 4.3 |  | 12 | 3.5 | 110 | 1.6
60 | 20 | 9.5 | 8.9 | 8.3 | 7.8 | 7.2 |  | 12 | 4.5 | 110 | 2.3
70 | 12 | 3 | 2.8 | 2.6 | 2.4 | 2.2 |  | 15 | 2 | 30 | 0.6
70 | 15 | 4.4 | 4 | 3.8 | 3.5 | 3.3 |  | 15 | 3 | 30 | 1.6
70 | 18 | 6 | 5.5 | 5.1 | 4.8 | 4.4 |  | 15 | 4 | 30 | 2.6
70 | 24 | 9.7 | 9.1 | 8.5 | 7.9 | 7.3 |  | 15 | 5 | 30 | 3.7
 |  |  |  |  |  |  |  | 15 | 2 | 50 | 0.6
 |  |  |  |  |  |  |  | 15 | 3 | 50 | 1.6
 |  |  |  |  |  |  |  | 15 | 4 | 50 | 2.6
 |  |  |  |  |  |  |  | 15 | 5 | 50 | 3.7
 |  |  |  |  |  |  |  | 15 | 2 | 70 | 0.6
 |  |  |  |  |  |  |  | 15 | 3 | 70 | 1.6
 |  |  |  |  |  |  |  | 15 | 4 | 70 | 2.6
 |  |  |  |  |  |  |  | 15 | 5 | 70 | 3.6
 |  |  |  |  |  |  |  | 15 | 2 | 90 | 0.6
 |  |  |  |  |  |  |  | 15 | 3 | 90 | 1.6
 |  |  |  |  |  |  |  | 15 | 4 | 90 | 2.6
 |  |  |  |  |  |  |  | 15 | 5 | 90 | 3.6
 |  |  |  |  |  |  |  | 15 | 2 | 110 | 0.6
 |  |  |  |  |  |  |  | 15 | 3 | 110 | 1.6
 |  |  |  |  |  |  |  | 15 | 4 | 110 | 2.5
 |  |  |  |  |  |  |  | 15 | 5 | 110 | 3.5
 |  |  |  |  |  |  |  | 18 | 3 | 30 | 1.6
 |  |  |  |  |  |  |  | 18 | 4 | 30 | 2.9
 |  |  |  |  |  |  |  | 18 | 5 | 30 | 4.2
 |  |  |  |  |  |  |  | 18 | 6 | 30 | 6
 |  |  |  |  |  |  |  | 18 | 3 | 50 | 1.6
 |  |  |  |  |  |  |  | 18 | 4 | 50 | 2.9
 |  |  |  |  |  |  |  | 18 | 5 | 50 | 4.2
 |  |  |  |  |  |  |  | 18 | 6 | 50 | 5.8
 |  |  |  |  |  |  |  | 18 | 3 | 70 | 1.5
 |  |  |  |  |  |  |  | 18 | 4 | 70 | 2.8
 |  |  |  |  |  |  |  | 18 | 5 | 70 | 4.1
 |  |  |  |  |  |  |  | 18 | 6 | 70 | 5.7
 |  |  |  |  |  |  |  | 18 | 3 | 90 | 1.5
 |  |  |  |  |  |  |  | 18 | 4 | 90 | 2.8
 |  |  |  |  |  |  |  | 18 | 5 | 90 | 4
 |  |  |  |  |  |  |  | 18 | 6 | 90 | 5.6
 |  |  |  |  |  |  |  | 18 | 3 | 110 | 1.4
 |  |  |  |  |  |  |  | 18 | 4 | 110 | 2.7
 |  |  |  |  |  |  |  | 18 | 5 | 110 | 3.9
 |  |  |  |  |  |  |  | 18 | 6 | 110 | 5.5
 |  |  |  |  |  |  |  | 24 | 3 | 30 | 1.1
 |  |  |  |  |  |  |  | 24 | 4.5 | 30 | 2.1
 |  |  |  |  |  |  |  | 24 | 6 | 30 | 4.1
 |  |  |  |  |  |  |  | 24 | 8 | 30 | 4.5
 |  |  |  |  |  |  |  | 24 | 3 | 50 | 1.1
 |  |  |  |  |  |  |  | 24 | 4.5 | 50 | 2
 |  |  |  |  |  |  |  | 24 | 6 | 50 | 4
 |  |  |  |  |  |  |  | 24 | 8 | 50 | 4.4
 |  |  |  |  |  |  |  | 24 | 3 | 70 | 0.9
 |  |  |  |  |  |  |  | 24 | 4.5 | 70 | 1.8
 |  |  |  |  |  |  |  | 24 | 6 | 70 | 3.8
 |  |  |  |  |  |  |  | 24 | 8 | 70 | 4.1
 |  |  |  |  |  |  |  | 24 | 3 | 90 | 0.8
 |  |  |  |  |  |  |  | 24 | 4.5 | 90 | 1.7
 |  |  |  |  |  |  |  | 24 | 6 | 90 | 3.7
 |  |  |  |  |  |  |  | 24 | 8 | 90 | 3.9
 |  |  |  |  |  |  |  | 24 | 3 | 110 | 0.6
 |  |  |  |  |  |  |  | 24 | 4.5 | 110 | 1.5
 |  |  |  |  |  |  |  | 24 | 6 | 110 | 3.5
 |  |  |  |  |  |  |  | 24 | 8 | 110 | 3.7
 |  |  |  |  |  |  |  | 30 | 4 | 30 | 1.5
 |  |  |  |  |  |  |  | 30 | 6 | 30 | 3
 |  |  |  |  |  |  |  | 30 | 8 | 30 | 5.1
 |  |  |  |  |  |  |  | 30 | 10 | 30 | 7.7
 |  |  |  |  |  |  |  | 30 | 4 | 50 | 1.4
 |  |  |  |  |  |  |  | 30 | 6 | 50 | 2.8
 |  |  |  |  |  |  |  | 30 | 8 | 50 | 4.8
 |  |  |  |  |  |  |  | 30 | 10 | 50 | 7.2
 |  |  |  |  |  |  |  | 30 | 4 | 70 | 1.3
 |  |  |  |  |  |  |  | 30 | 6 | 70 | 2.7
 |  |  |  |  |  |  |  | 30 | 8 | 70 | 4.5
 |  |  |  |  |  |  |  | 30 | 10 | 70 | 6.8
 |  |  |  |  |  |  |  | 30 | 4 | 90 | 1.2
 |  |  |  |  |  |  |  | 30 | 6 | 90 | 2.5
 |  |  |  |  |  |  |  | 30 | 8 | 90 | 4.2
 |  |  |  |  |  |  |  | 30 | 10 | 90 | 6.3
 |  |  |  |  |  |  |  | 30 | 4 | 110 | 1.1
 |  |  |  |  |  |  |  | 30 | 6 | 110 | 2.3
 |  |  |  |  |  |  |  | 30 | 8 | 110 | 3.9
 |  |  |  |  |  |  |  | 30 | 10 | 110 | 5.8
 |  |  |  |  |  |  |  | 36 | 5 | 30 | 1
 |  |  |  |  |  |  |  | 36 | 7 | 30 | 2.1
 |  |  |  |  |  |  |  | 36 | 9 | 30 | 3.6
 |  |  |  |  |  |  |  | 36 | 12 | 30 | 6.3
 |  |  |  |  |  |  |  | 36 | 5 | 50 | 1
 |  |  |  |  |  |  |  | 36 | 7 | 50 | 1.9
 |  |  |  |  |  |  |  | 36 | 9 | 50 | 3.3
 |  |  |  |  |  |  |  | 36 | 12 | 50 | 5.9
 |  |  |  |  |  |  |  | 36 | 5 | 70 | 0.9
 |  |  |  |  |  |  |  | 36 | 7 | 70 | 1.8
 |  |  |  |  |  |  |  | 36 | 9 | 70 | 3
 |  |  |  |  |  |  |  | 36 | 12 | 70 | 5.5
 |  |  |  |  |  |  |  | 36 | 5 | 90 | 0.8
 |  |  |  |  |  |  |  | 36 | 7 | 90 | 1.7
 |  |  |  |  |  |  |  | 36 | 9 | 90 | 2.8
 |  |  |  |  |  |  |  | 36 | 12 | 90 | 5.1
 |  |  |  |  |  |  |  | 36 | 5 | 110 | 0.8
 |  |  |  |  |  |  |  | 36 | 7 | 110 | 1.6
 |  |  |  |  |  |  |  | 36 | 9 | 110 | 2.6
 |  |  |  |  |  |  |  | 36 | 12 | 110 | 4.8
 |  |  |  |  |  |  |  | 42 | 5 | 30 | 0.8
 |  |  |  |  |  |  |  | 42 | 8 | 30 | 2.1
 |  |  |  |  |  |  |  | 42 | 11 | 30 | 4.2
 |  |  |  |  |  |  |  | 42 | 14 | 30 | 7.6
 |  |  |  |  |  |  |  | 42 | 5 | 50 | 0.7
 |  |  |  |  |  |  |  | 42 | 8 | 50 | 2.1
 |  |  |  |  |  |  |  | 42 | 11 | 50 | 4.1
 |  |  |  |  |  |  |  | 42 | 14 | 50 | 6.7
 |  |  |  |  |  |  |  | 42 | 5 | 70 | 0.7
 |  |  |  |  |  |  |  | 42 | 8 | 70 | 1.9
 |  |  |  |  |  |  |  | 42 | 11 | 70 | 3.8
 |  |  |  |  |  |  |  | 42 | 14 | 70 | 6.3
 |  |  |  |  |  |  |  | 42 | 5 | 90 | 0.7
 |  |  |  |  |  |  |  | 42 | 8 | 90 | 1.8
 |  |  |  |  |  |  |  | 42 | 11 | 90 | 3.5
 |  |  |  |  |  |  |  | 42 | 14 | 90 | 5.8
 |  |  |  |  |  |  |  | 42 | 5 | 110 | 0.6
 |  |  |  |  |  |  |  | 42 | 8 | 110 | 1.7
 |  |  |  |  |  |  |  | 42 | 11 | 110 | 3.3
 |  |  |  |  |  |  |  | 42 | 14 | 110 | 5.4
 |  |  |  |  |  |  |  | 48 | 6 | 30 | 1.1
 |  |  |  |  |  |  |  | 48 | 9 | 30 | 2.3
 |  |  |  |  |  |  |  | 48 | 12 | 30 | 3.9
 |  |  |  |  |  |  |  | 48 | 16 | 30 | 6.7
 |  |  |  |  |  |  |  | 48 | 6 | 50 | 1
 |  |  |  |  |  |  |  | 48 | 9 | 50 | 2.1
 |  |  |  |  |  |  |  | 48 | 12 | 50 | 3.7
 |  |  |  |  |  |  |  | 48 | 16 | 50 | 6.3
 |  |  |  |  |  |  |  | 48 | 6 | 70 | 1
 |  |  |  |  |  |  |  | 48 | 9 | 70 | 2
 |  |  |  |  |  |  |  | 48 | 12 | 70 | 3.4
 |  |  |  |  |  |  |  | 48 | 16 | 70 | 5.9
 |  |  |  |  |  |  |  | 48 | 6 | 90 | 0.9
 |  |  |  |  |  |  |  | 48 | 9 | 90 | 1.9
 |  |  |  |  |  |  |  | 48 | 12 | 90 | 3.2
 |  |  |  |  |  |  |  | 48 | 16 | 90 | 5.5
 |  |  |  |  |  |  |  | 48 | 6 | 110 | 0.8
 |  |  |  |  |  |  |  | 48 | 9 | 110 | 1.7
 |  |  |  |  |  |  |  | 48 | 12 | 110 | 3
 |  |  |  |  |  |  |  | 48 | 16 | 110 | 5.1
 |  |  |  |  |  |  |  | 60 | 9 | 30 | 2.4
 |  |  |  |  |  |  |  | 60 | 12 | 30 | 3.9
 |  |  |  |  |  |  |  | 60 | 15 | 30 | 5.7
 |  |  |  |  |  |  |  | 60 | 20 | 30 | 9.5
 |  |  |  |  |  |  |  | 60 | 9 | 50 | 2.2
 |  |  |  |  |  |  |  | 60 | 12 | 50 | 3.6
 |  |  |  |  |  |  |  | 60 | 15 | 50 | 5.3
 |  |  |  |  |  |  |  | 60 | 20 | 50 | 8.9
 |  |  |  |  |  |  |  | 60 | 9 | 70 | 2.1
 |  |  |  |  |  |  |  | 60 | 12 | 70 | 3.4
 |  |  |  |  |  |  |  | 60 | 15 | 70 | 5
 |  |  |  |  |  |  |  | 60 | 20 | 70 | 8.3
 |  |  |  |  |  |  |  | 60 | 9 | 90 | 2
 |  |  |  |  |  |  |  | 60 | 12 | 90 | 3.2
 |  |  |  |  |  |  |  | 60 | 15 | 90 | 4.7
 |  |  |  |  |  |  |  | 60 | 20 | 90 | 7.8
 |  |  |  |  |  |  |  | 60 | 9 | 110 | 1.8
 |  |  |  |  |  |  |  | 60 | 12 | 110 | 2.9
 |  |  |  |  |  |  |  | 60 | 15 | 110 | 4.3
 |  |  |  |  |  |  |  | 60 | 20 | 110 | 7.2
 |  |  |  |  |  |  |  | 70 | 12 | 30 | 3
 |  |  |  |  |  |  |  | 70 | 15 | 30 | 4.4
 |  |  |  |  |  |  |  | 70 | 18 | 30 | 6
 |  |  |  |  |  |  |  | 70 | 24 | 30 | 9.7
 |  |  |  |  |  |  |  | 70 | 12 | 50 | 2.8
 |  |  |  |  |  |  |  | 70 | 15 | 50 | 4
 |  |  |  |  |  |  |  | 70 | 18 | 50 | 5.5
 |  |  |  |  |  |  |  | 70 | 24 | 50 | 9.1
 |  |  |  |  |  |  |  | 70 | 12 | 70 | 2.6
 |  |  |  |  |  |  |  | 70 | 15 | 70 | 3.8
 |  |  |  |  |  |  |  | 70 | 18 | 70 | 5.1
 |  |  |  |  |  |  |  | 70 | 24 | 70 | 8.5
 |  |  |  |  |  |  |  | 70 | 12 | 90 | 2.4
 |  |  |  |  |  |  |  | 70 | 15 | 90 | 3.5
 |  |  |  |  |  |  |  | 70 | 18 | 90 | 4.8
 |  |  |  |  |  |  |  | 70 | 24 | 90 | 7.9
 |  |  |  |  |  |  |  | 70 | 12 | 110 | 2.2
 |  |  |  |  |  |  |  | 70 | 15 | 110 | 3.3
 |  |  |  |  |  |  |  | 70 | 18 | 110 | 4.4
 |  |  |  |  |  |  |  | 70 | 24 | 110 | 7.3