Spreadsheet: 726554d1617290455-trying-to-get-index-an-match-to-return-a-value-from-a-table-but-getting-no-results-index-match-with-pipe-size
Sheet: Manhole Rates

pipe in | 150 | 225 | 300 | 450 | 600 | 600 | 600 | 750 | 900 | 900 | 1050 | 1200 | [NAME] | [NAME] |  |  |  | Type 1
 | 1200mm | 1200mm | 1200mm | 1200mm | 1350mm | 1500mm | 1800mm | 2100[NAME] | 2100[NAME] | 2400mm | 2700mm | 3000mm | 500mm | 1050[NAME] |  |  |  | 1500mm
1 | 1775.242271511315 |  |  |  | 1954.48 | 2133.724131288935 | 2313.95996581375 | 3249.961546013941 | 3249.961546013941 | 4114.423490162652 | 4467.854972815431 | 5323.22308597931 | 543.3454734658236 | 709.0519063546767 |  |  |  |  |  | 358.4818597776198
1.25 | 1857.97689933018 |  |  |  | 2208.23 | 2558.476570417044 | 2728.256835055353 | 3879.134646462597 | 3879.134646462597 | 4771.836797369678 | 5378.146653500386 | 6356.394376575206 | 571.0393275444119 | 742.1879148627648 |  |  |  |  |  | 700.499671086864
1.5 | 1962.184285711543 |  |  |  | 2314.72 | 2667.261449218272 | 3021.217809783083 | 3866.871955424262 | 3866.871955424262 | 4582.695939422824 | 4884.210021796838 | 5895.46608394715 | 598.7331816230001 | 784.2619074083532 |  |  |  |  |  | 705.077163506729
1.75 | 2077.459807405408 |  |  |  | 2441.51 | 2805.558213394501 | 3123.789540533513 | 4240.081475524245 | 4240.081475524245 | 5031.519319189582 | 5332.700910875313 | 6423.45621859337 | 626.4270357015884 | 868.696808607618 |  |  | 5 | 5810.138845574456 |  | 728.098405989093
2 | 2237.211097352949 |  |  |  | 2599.69 | 2962.15942675823 | 3261.797528608945 | 4376.465186066675 | 4376.465186066675 | 5854.673053478333 | 6209.968375763463 | 7337.98207663705 | 654.1208897801766 | 910.7708011532061 |  |  | 5.25 | 6068.295437040465 |  | 724.9483294052811
2.25 | 2396.338619046813 |  |  |  | 2783.41 | 3170.472722250635 | 3423.162712346876 | 4567.931918921606 | 4567.931918921606 | 6028.042304735475 | 6735.223062828693 | 8046.086444339418 | 681.8147438587648 | 943.9068096612945 |  |  | 5.5 | 6285.423994062027 |  | 774.1341032038217
2.5 | 2500.546005428178 |  |  |  | 2948.06 | 3395.568935614363 | 3641.308016363483 | 4801.859757964035 | 4801.859757964035 | 6272.004002567617 | 6888.533160156957 | 8544.382545334414 | 709.5085979373531 | 985.9808022068826 |  |  | 5.75 | 6485.425581083594 |  | 895.0229301861859
2.75 | 2615.821527122042 |  |  |  | 3074.84 | 3533.865699790592 | 3871.168200101414 | 5127.342320370435 | 5127.342320370435 | 6572.491167562258 | 7121.072881997719 | 8731.044556993773 | 737.2024520159413 | 1070.415703406147 |  |  | 6 | 6696.84514810516 |  | 918.0441726685499
3 | 2842.984340424877 |  |  |  | 3303.77 | 3764.555680475955 | 4051.205073603383 | 5543.800389105006 | 5543.800389105006 | 7137.987330356185 | 7702.666602500981 | 9311.352243728132 | 764.8963060945296 | 1112.489695951735 |  |  | 6.25 | 6905.41022012672 |  | 921.5713400510781
3.25 | 3196.468345216977 |  |  |  | 3586.41 | 3976.34775109589 | 4214.272557030255 | 5726.942426121867 | 5726.942426121867 | 7427.420451349924 | 8130.718433341744 | 9699.250708374988 | 0 | 0 |  |  | 6.5 | 7113.97529214829 |  | 779.8794058789126
3.5 | 3328.824565696577 |  |  |  | 3857.4 | 4385.98061311656 | 4983.316532237321 | 5952.545569326228 | 5952.545569326228 | 7660.328105181165 | 8427.312153845003 | 10247.14406260935 |  |  |  |  | 6.75 | 7322.54036416985 |  | 1057.156047419983
3.75 | 3472.248921488676 |  |  |  | 4012.62 | 4552.999376949729 | 5135.343874838244 | 6917.729073870629 | 6917.729073870629 | 7949.761226174905 | 8659.851875685767 | 10635.04252725621 |  |  |  |  | 7 | 7531.10543619141 |  | 1080.750455461053
4 | 3661.808282005041 |  |  |  | 4200.07 | 4738.322589970398 | 5300.121437001667 | 7097.035129907417 | 7097.035129907417 | 8941.993437541365 | 8956.445596189029 | 10930.35021399056 |  |  |  |  | 7.25 | 7739.67050821298 |  | 1076.514307965358
4.25 | 3805.23263779714 |  |  |  | 4391.12 | 4977.017121590333 | 5475.96713447759 | 7289.091405506705 | 7289.091405506705 | 9161.49979615021 | 9424.426701517294 | 11318.24867863742 |  |  |  |  | 7.5 | 7948.23558023454 |  | 1171.784483793193
4.5 | 3937.58885827674 |  |  |  | 4549.96 | 5162.340334611003 | 5697.947836677778 | 7492.215816418492 | 7492.215816418492 | 9393.756374321558 | 10166.30354997104 | 11866.14203287178 |  |  |  |  | 7.75 | 8156.8006522561 |  | 1224.751476334262
4.75 | 4081.01321406884 |  |  |  | 4705.19 | 5329.359098444173 | 5873.7935341537 | 7740.10277264278 | 7740.10277264278 | 9637.081087805407 | 10385.80990857988 | 12791.10912350638 |  |  |  |  | 8 | 8365.36572427768 |  | 1248.345884375334
5 | 4270.572574585204 |  |  |  | 4892.63 | 5514.682311464842 | 6038.571096317124 | 7943.227183554569 | 7943.227183554569 | 9925.168346601753 | 10618.06648675123 | 13056.17582503023 |  |  |  |  | 8.25 | 8573.93079629922 |  | 1244.109736879638
5.25 | 4413.996930377304 |  |  |  | 5083.69 | 5753.376843084776 | 6214.416793793047 | 8135.283459153859 | 8135.283459153859 | 10168.4930600856 | 10861.39120023508 | 13333.99274611658 |  |  |  |  | 8.5 | 8782.49586832078 |  | 1339.379912707472
5.5 | 4546.353150856903 |  |  |  | 5242.53 | 5938.700056105445 | 6436.397495993236 | 8338.407870065645 | 8338.407870065645 | 10400.74963825694 | 11149.47845903142 | 13622.87780251542 |  |  |  |  | 8.75 | 8991.06094034234 |  | 1392.346905248542
5.75 | 4689.777506649003 |  |  |  | 5397.75 | 6105.718819938616 | 6612.243193469159 | 8586.294826289934 | 8586.294826289934 | 10644.07435174079 | 11392.80317251527 | 13956.52540422677 |  |  |  |  | 9 | 9199.6260123639 |  | 1415.941313289613
6 | 4879.336867165369 |  |  |  | 5585.19 | 6291.042032959285 | 6777.020755632582 | 8789.41923720172 | 8789.41923720172 | 10932.16161053714 | 11625.05975068662 | 14225.90718601312 |  |  |  |  | 9.25 | 9408.19108438546 |  | 1411.705165793916
E.O. Cover to Soffit <1.5m
750mm x 750[NAME] | 169.9051725 | 169.9051725 | 169.9051725 | 169.9051725
1200mm x 675[NAME] |  |  |  |  | 218.1598334999999 | 203.4546884999999 | 218.1598334999999 | 271.1234925000001 | 271.1234925000001 | 232.3245329999999 | 211.187458125 | 289.5866189999998
E.O. D400 cover & frame |  |  |  |  |  |  |  |  |  |  |  |  | 51.24774159529412 | 109.7405777647059
E.O. GRP Handrailings | 855.0000000000001 | 855.0000000000001 | 855.0000000000001 | 855.0000000000001 | 855.0000000000001 | 855.0000000000001 | 855.0000000000001 | 877.8000000000001 | 877.8000000000001 | 877.8000000000001 | 957.6000000000001 | 1014.6
E.O. AMPS | 1424.648477647059 | 1424.648477647059 | 1424.648477647059 | 1424.648477647059 | 1506.642977647059 | 1588.637477647059 | 2062.649477647059 | 2442.194640000001 | 2442.194640000001 | 2917.40364 | 3555.40464 | 3882.18564
E.O. Safety Handhold | 359.1 | 359.1 | 359.1 | 359.1 | 359.1 | 359.1 | 359.1 | 359.1 | 359.1 | 359.1 | 359.1 | 359.1
Shallow | Access | Access | Access | Access
150mm | Full Height | Full Height | Full Height | Full Height
300mm | Chimney | Chimney | Chimney | Chimney
450mm
600mm
900mm
1200mm