Spreadsheet: 34917d1232373638-excel-2007-searching-tables-returning-multiple-cells-book222
Sheet: Sheet1

 |  | 750 | 900 | 1050 | 1200 | 1350 | 1500 | 1650 | 1800 | 1950 | 2100 | 2250 | 2400 | 2550 | 2700 | 2850 | 3000 | width
 | 750 | 36.75 | 44.1 | 51.45 | 58.8 | 66.15 | 73.5 | 80.85 | 88.2 | 95.55 | 102.9 | 110.25 | 117.6 | 124.95 | 132.3 | 139.65 | 147
 | 900 | 44.1 | 52.92 | 61.74 | 70.56 | 79.38 | 88.2 | 97.02 | 105.84 | 114.66 | 123.48 | 132.3 | 141.12 | 149.94 | 158.76 | 167.58 | 176.4
Lined | 1050 | 51.45 | 61.74 | 72.03 | 82.32 | 92.61 | 102.9 | 113.19 | 123.48 | 133.77 | 144.06 | 154.35 | 164.64 | 174.93 | 185.22 | 195.51 | 205.8
 | 1200 | 58.8 | 70.56 | 82.32 | 94.08 | 105.84 | 117.6 | 129.36 | 141.12 | 152.88 | 164.64 | 176.4 | 188.16 | 199.92 | 211.68 | 223.44 | 235.2 |  | Interlined |  | fill in lined, interlined, machined works fine goes to that table
 | 1350 | 66.15 | 79.38 | 92.61 | 105.84 | 119.07 | 132.3 | 145.53 | 158.76 | 171.99 | 185.22 | 198.45 | 211.68 | 224.91 | 238.14 | 251.37 | 264.6
 | 1500 | 73.5 | 88.2 | 102.9 | 117.6 | 132.3 | 147 | 161.7 | 176.4 | 191.1 | 205.8 | 220.5 | 235.2 | 249.9 | 264.6 | 279.3 | 294 | w | 1200
 | 1650 | 80.85 | 97.02 | 113.19 | 129.36 | 145.53 | 161.7 | 177.87 | 194.04 | 210.21 | 226.38 | 242.55 | 258.72 | 274.89 | 291.06 | 307.23 | 323.4
 | 1800 | 88.2 | 105.84 | 123.48 | 141.12 | 158.76 | 176.4 | 194.04 | 211.68 | 229.32 | 246.96 | 264.6 | 282.24 | 299.88 | 317.52 | 335.16 | 352.8 | d | 900 |  |  | looking for one coloured square
 | 1950 | 95.55 | 114.66 | 133.77 | 152.88 | 171.99 | 191.1 | 210.21 | 229.32 | 248.43 | 267.54 | 286.65 | 305.76 | 324.87 | 343.98 | 363.09 | 382.2 |  |  |  |  | looks for the width first then the drop and then fills in the colour
 | 2100 | 102.9 | 123.48 | 144.06 | 164.64 | 185.22 | 205.8 | 226.38 | 246.96 | 267.54 | 288.12 | 308.7 | 329.28 | 349.86 | 370.44 | 391.02 | 411.6 |  |  |  |  | got the colour working, but its picking out all values in the table = to T15
 | 2250 | 110.25 | 132.3 | 154.35 | 176.4 | 198.45 | 220.5 | 242.55 | 264.6 | 286.65 | 308.7 | 330.75 | 352.8 | 374.85 | 396.9 | 418.95 | 441
 | 2400 | 117.6 | 141.12 | 164.64 | 188.16 | 211.68 | 235.2 | 258.72 | 282.24 | 305.76 | 329.28 | 352.8 | 376.32 | 399.84 | 423.36 | 446.88 | 470.4
 | 2550 | 124.95 | 149.94 | 174.93 | 199.92 | 224.91 | 249.9 | 274.89 | 299.88 | 324.87 | 349.86 | 374.85 | 399.84 | 424.83 | 449.82 | 474.81 | 499.8
 | 2700 | 132.3 | 158.76 | 185.22 | 211.68 | 238.14 | 264.6 | 291.06 | 317.52 | 343.98 | 370.44 | 396.9 | 423.36 | 449.82 | 476.28 | 502.74 | 529.2
 | 2850 | 139.65 | 167.58 | 195.51 | 223.44 | 251.37 | 279.3 | 307.23 | 335.16 | 363.09 | 391.02 | 418.95 | 446.88 | 474.81 | 502.74 | 530.67 | 558.6
 | 3000 | 147 | 176.4 | 205.8 | 235.2 | 264.6 | 294 | 323.4 | 352.8 | 382.2 | 411.6 | 441 | 470.4 | 499.8 | 529.2 | 558.6 | 588
 | drop
 |  | 750 | 900 | 1050 | 1200 | 1350 | 1500 | 1650 | 1800 | 1950 | 2100 | 2250 | 2400 | 2550 | 2700 | 2850 | 3000 | width
 | 750 | 47.75 | 57.3 | 66.85 | 76.39999999999999 | 85.95 | 95.5 | 105.05 | 114.6 | 124.15 | 133.7 | 143.25 | 152.8 | 162.35 | 171.9 | 181.45 | 191
 | 900 | 57.3 | 68.75999999999999 | 80.22 | 91.67999999999999 | 103.14 | 114.6 | 126.06 | 137.52 | 148.98 | 160.44 | 171.9 | 183.36 | 194.82 | 206.28 | 217.74 | 229.2
Interlined | 1050 | 66.85 | 80.22 | 93.58999999999999 | 106.96 | 120.33 | 133.7 | 147.07 | 160.44 | 173.81 | 187.18 | 200.55 | 213.92 | 227.29 | 240.66 | 254.03 | 267.4
 | 1200 | 76.39999999999999 | 91.67999999999999 | 106.96 | 122.24 | 137.52 | 152.8 | 168.08 | 183.36 | 198.64 | 213.92 | 229.2 | 244.48 | 259.76 | 275.04 | 290.32 | 305.6
 | 1350 | 85.95 | 103.14 | 120.33 | 137.52 | 154.71 | 171.9 | 189.09 | 206.28 | 223.47 | 240.66 | 257.85 | 275.04 | 292.23 | 309.42 | 326.61 | 343.8
 | 1500 | 95.5 | 114.6 | 133.7 | 152.8 | 171.9 | 191 | 210.1 | 229.2 | 248.3 | 267.4 | 286.5 | 305.6 | 324.7 | 343.8 | 362.9 | 382
 | 1650 | 105.05 | 126.06 | 147.07 | 168.08 | 189.09 | 210.1 | 231.11 | 252.12 | 273.13 | 294.14 | 315.15 | 336.16 | 357.17 | 378.18 | 399.19 | 420.2
 | 1800 | 114.6 | 137.52 | 160.44 | 183.36 | 206.28 | 229.2 | 252.12 | 275.04 | 297.96 | 320.88 | 343.8 | 366.72 | 389.64 | 412.56 | 435.48 | 458.4
 | 1950 | 124.15 | 148.98 | 173.81 | 198.64 | 223.47 | 248.3 | 273.13 | 297.96 | 322.79 | 347.62 | 372.45 | 397.28 | 422.11 | 446.94 | 471.77 | 496.6
 | 2100 | 133.7 | 160.44 | 187.18 | 213.92 | 240.66 | 267.4 | 294.14 | 320.88 | 347.62 | 374.36 | 401.1 | 427.84 | 454.58 | 481.32 | 508.06 | 534.8
 | 2250 | 143.25 | 171.9 | 200.55 | 229.2 | 257.85 | 286.5 | 315.15 | 343.8 | 372.45 | 401.1 | 429.75 | 458.4 | 487.05 | 515.6999999999999 | 544.35 | 573
 | 2400 | 152.8 | 183.36 | 213.92 | 244.48 | 275.04 | 305.6 | 336.16 | 366.72 | 397.28 | 427.84 | 458.4 | 488.96 | 519.52 | 550.0799999999999 | 580.64 | 611.1999999999999
 | 2550 | 162.35 | 194.82 | 227.29 | 259.76 | 292.23 | 324.7 | 357.17 | 389.64 | 422.11 | 454.58 | 487.05 | 519.52 | 551.99 | 584.4599999999999 | 616.93 | 649.4
 | 2700 | 171.9 | 206.28 | 240.66 | 275.04 | 309.42 | 343.8 | 378.18 | 412.56 | 446.94 | 481.32 | 515.6999999999999 | 550.0799999999999 | 584.4599999999999 | 618.8399999999999 | 653.22 | 687.6
 | 2850 | 181.45 | 217.74 | 254.03 | 290.32 | 326.61 | 362.9 | 399.19 | 435.48 | 471.77 | 508.06 | 544.35 | 580.64 | 616.93 | 653.22 | 689.51 | 725.8
 | 3000 | 191 | 229.2 | 267.4 | 305.6 | 343.8 | 382 | 420.2 | 458.4 | 496.6 | 534.8 | 573 | 611.1999999999999 | 649.4 | 687.6 | 725.8 | 764
 | drop
 |  | 750 | 900 | 1050 | 1200 | 1350 | 1500 | 1650 | 1800 | 1950 | 2100 | 2250 | 2400 | 2550 | 2700 | 2850 | 3000 | width
 | 750 | 30.125 | 36.15000000000001 | 42.175 | 48.2 | 54.225 | 60.25 | 66.275 | 72.30000000000001 | 78.325 | 84.35000000000001 | 90.375 | 96.4 | 102.425 | 108.45 | 114.475 | 120.5
 | 900 | 36.15000000000001 | 43.38 | 50.61 | 57.84 | 65.07000000000001 | 72.30000000000001 | 79.53 | 86.76 | 93.99000000000001 | 101.22 | 108.45 | 115.68 | 122.91 | 130.14 | 137.37 | 144.6
Machined | 1050 | 42.175 | 50.61 | 59.045 | 67.48 | 75.915 | 84.35000000000001 | 92.78500000000001 | 101.22 | 109.655 | 118.09 | 126.525 | 134.96 | 143.395 | 151.83 | 160.265 | 168.7
 | 1200 | 48.2 | 57.84 | 67.48 | 77.12 | 86.76 | 96.4 | 106.04 | 115.68 | 125.32 | 134.96 | 144.6 | 154.24 | 163.88 | 173.52 | 183.16 | 192.8
 | 1350 | 54.225 | 65.07000000000001 | 75.915 | 86.76 | 97.605 | 108.45 | 119.295 | 130.14 | 140.985 | 151.83 | 162.675 | 173.52 | 184.365 | 195.21 | 206.055 | 216.9
 | 1500 | 60.25 | 72.30000000000001 | 84.35000000000001 | 96.4 | 108.45 | 120.5 | 132.55 | 144.6 | 156.65 | 168.7 | 180.75 | 192.8 | 204.85 | 216.9 | 228.95 | 241
 | 1650 | 66.275 | 79.53 | 92.78500000000001 | 106.04 | 119.295 | 132.55 | 145.805 | 159.06 | 172.315 | 185.57 | 198.825 | 212.08 | 225.335 | 238.59 | 251.845 | 265.1
 | 1800 | 72.30000000000001 | 86.76 | 101.22 | 115.68 | 130.14 | 144.6 | 159.06 | 173.52 | 187.98 | 202.44 | 216.9 | 231.36 | 245.82 | 260.28 | 274.74 | 289.2
 | 1950 | 78.325 | 93.99000000000001 | 109.655 | 125.32 | 140.985 | 156.65 | 172.315 | 187.98 | 203.645 | 219.31 | 234.975 | 250.64 | 266.305 | 281.97 | 297.635 | 313.3
 | 2100 | 84.35000000000001 | 101.22 | 118.09 | 134.96 | 151.83 | 168.7 | 185.57 | 202.44 | 219.31 | 236.18 | 253.05 | 269.92 | 286.79 | 303.66 | 320.53 | 337.4
 | 2250 | 90.375 | 108.45 | 126.525 | 144.6 | 162.675 | 180.75 | 198.825 | 216.9 | 234.975 | 253.05 | 271.125 | 289.2 | 307.275 | 325.35 | 343.425 | 361.5
 | 2400 | 96.4 | 115.68 | 134.96 | 154.24 | 173.52 | 192.8 | 212.08 | 231.36 | 250.64 | 269.92 | 289.2 | 308.48 | 327.76 | 347.04 | 366.3200000000001 | 385.6
 | 2550 | 102.425 | 122.91 | 143.395 | 163.88 | 184.365 | 204.85 | 225.335 | 245.82 | 266.305 | 286.79 | 307.275 | 327.76 | 348.245 | 368.73 | 389.215 | 409.7
 | 2700 | 108.45 | 130.14 | 151.83 | 173.52 | 195.21 | 216.9 | 238.59 | 260.28 | 281.97 | 303.66 | 325.35 | 347.04 | 368.73 | 390.42 | 412.11 | 433.8
 | 2850 | 114.475 | 137.37 | 160.265 | 183.16 | 206.055 | 228.95 | 251.845 | 274.74 | 297.635 | 320.53 | 343.425 | 366.3200000000001 | 389.215 | 412.11 | 435.0050000000001 | 457.9
 | 3000 | 120.5 | 144.6 | 168.7 | 192.8 | 216.9 | 241 | 265.1 | 289.2 | 313.3 | 337.4 | 361.5 | 385.6 | 409.7 | 433.8 | 457.9 | 482
 | drop