Spreadsheet: 217457d1362070911-looking-up-value-by-closest-match-and-determining-cell-address-test-mk1
Sheet: Sheet1

 |  | Inside Diameters ([NAME])
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | Calculated Value
 |  | Schedule - Wall Thickness |  |  |  |  |  |  |  |  | 273.45 | [NAME] | 273.45
 |  | 5 | 10 |  | 40 | 80 | 160 | Double Extra Strong |  |  |  |  |  |  |  |  |  |  | 10s | 40s | 80s
NB (") |  | 0 | 0 | 0 | 6.83 | 5.47 | 0 | 0 |  |  | Required pipe |  |  |  |  |  |  |  | 7.81 | 6.83 | 5.47
 |  | 0 | 0 | 0 | 9.24 | 7.68 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 10.42 | 9.24 | 7.68
 |  | 0 | 0 | 0 | 12.53 | 10.75 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 13.58 | 12.53 | 10.75
 |  | 18.04 | 0 | 0 | 15.8 | 13.88 | 11.84 | 6.4 |  |  |  | 1st attempt |  |  |  |  |  |  | 17.12 | 15.8 | 13.88
 |  | 23.37 | 0 | 0 | 20.93 | 18.85 | 15.59 | 11.03 |  |  |  | 2nd attempt Simplified |  |  |  |  |  |  | 22.45 | 20.93 | 18.85
 | 1 | 30.1 | 0 | 0 | 26.64 | 24.3 | 20.7 | 15.22 |  |  |  | 3rd Attempt |  |  |  |  |  |  | 27.85 | 26.64 | 24.3
 |  | 38.26 | 0 | 0 | 35.04 | 32.46 | 29.46 | 22.76 |  |  |  |  |  |  |  |  |  |  | 36.62 | 35.04 | 32.46
 | 1.5 | 44.96 | 0 | 0 | 40.88 | 38.1 | 33.98 | 27.94 |  |  |  | << Text, thus not much can be done with this |  |  |  |  |  |  | 42.72 | 40.88 | 38.1
 | 2 | 57.03 | 0 | 0 | 52.51 | 49.25 | 42.91 | 38.19 |  |  |  |  |  |  |  |  |  |  | 54.79 | 52.51 | 49.25
 | 2.5 | 68.81 | 0 | 0 | 62.71 | 59.01 | 53.97 | 44.99 |  |  |  |  |  |  |  |  |  |  | 66.93 | 62.71 | 59.01
 | 3 | 64.68 | 0 | 0 | 77.92 | 73.66 | 66.64 | 58.42 |  |  |  |  |  |  |  |  |  |  | 82.8 | 77.92 | 73.66
 | 3.5 | 97.38 | 0 | 0 | 90.12 | 85.44 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 95.5 | 90.12 | 85.44
 | 4 | 110.08 | 0 | 0 | 102.26 | 97.18 | 87.32 | 80.06 |  | [NAME] results |  |  |  |  |  |  |  |  | 108.2 | 102.26 | 97.18
 | 5 | 135.76 | 0 | 0 | 128.2 | 122.24 | 100.54 | 103.2 |  | Match |  |  |  |  |  |  |  |  | 134.5 | 128.2 | 122.24
 | 6 | 162.74 | 0 | 0 | 154.06 | 146.34 | 131.8 | 124.38 |  | Match + 1 |  |  |  |  |  |  |  |  | 161.48 | 154.06 | 146.34
 | 8 | 213.54 | 0 | 206.38 | 202.72 | 193.68 | 173.06 | 174.64 |  | Address |  |  |  |  |  |  |  |  | 211.56 | 202.72 | 193.68
 | 10 | 266.25 | 0 | 260.35 | 254.51 | 242.93 | 215.89 | 0 |  | Value |  |  |  |  |  |  |  |  | 264.57 | 254.51 | 247.65
 | 12 | 315.93 | 0 | 311.15 | 303.23 | 288.95 | 257.19 | 0 |  |  | b | c | d | e | f | g | h |  | 314.71 | 304.79 | 298.45
 | 14 | 347.68 | 342.9 | 339.76 | 333.34 | 317.5 | 284.18 | 0 |  |  |  |  |  |  |  |  |  |  | 346.05 | 336.54 | 330.02
 | 16 | 398.02 | 393.7 | 390.56 | 381.09 | 363.58 | 325.48 | 0 |  |  |  |  |  |  |  |  |  |  | 396.04 | 387.34 | 381.09
 | 18 | 448.82 | 444.5 | 441.36 | 428.66 | 409.6 | 366.72 | 0 |  |  |  |  |  |  |  |  |  |  | 447.64 | 438.14 | 431.8
 | 20 | 496.44 | 495.3 | 488.94 | 477.88 | 455.62 | 408.02 | 0 |  |  |  |  | Min |  |  |  |  |  | 496.94 | 488.94 | 482.6
 | 24 | 598.52 | 596.9 | 590.54 | 574.7 | 547.72 | 490.58 | 0 |  |  |  |  |  |  |  |  |  |  | 596.9 | 590.54 | 584.2
 |  |  |  |  |  |  |  |  |  |  |  |  | NB =
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | a | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | b | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | Schedule = |  |  |  |  |  |  |  | c | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | e | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | f | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | g | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | h | 9