Spreadsheet: 476068d1471599682-vlookup-with-indirect-and-substitute-quoteform-test
Sheet: Biography

CODE | [NAME] | Column1 | PG0 | PG04 | PG07 | [NAME] | PG12
BFH10 | 1000mm double base unit, full height c/w 1 adjustable shelf | pce | 107.226 | 170.568 | 189.198 | 194.58 | 220.662
BFH10POD | 1000mm single base unit, full height c/w blum drawer pull out, 2 deep 1 shallow | pce | 357.6959999999999 | 405.72 | 416.07 | 426.006 | 456.6419999999999
BFH12 | 1200mm double base unit, full height c/w 1 adjustable shelf | pce | 114.264 | 182.574 | 201.204 | 209.898 | 240.948
BFH12POD | 1200mm single base unit, full height c/w blum drawer pull out, 2 deep 1 shallow | pce | 362.664 | 412.7579999999999 | 423.936 | 434.7 | 468.6479999999999
BFH2.6 | 260[NAME] single base unit, full height c/w 1 adjustable shelf | pce | 67.89599999999999 | 93.14999999999999 | 100.602 | 102.672 | 111.366
BFH2PO1D1S | 200[NAME] single base unit, full height c/w 1 deep drawer and 1 shallow drawer both attached to the door | pce | 194.166 | 216.936 | 226.044 | 228.528 | 235.5659999999999
BFH3 | 300[NAME] unit, full height c/w 1 adjustable shelf | pce | 69.55199999999999 | 95.21999999999998 | 104.328 | 106.812 | 115.506
BFH3.5 | 350[NAME] single base unit, full height c/w 1 adjustable shelf | pce | 71.62199999999999 | 98.53199999999998 | 107.64 | 110.124 | 119.646
BFH3ACPO | 300[NAME] unit, full height c/w arena classic chrome wire pull out | pce | 214.038 | 239.7059999999999 | 247.986 | 250.47 | 259.578
BFH3ASPO | 300[NAME] unit, full height c/w arena style chrome wire pull out | pce | 233.496 | 259.578 | 267.8579999999999 | 269.9279999999999 | 279.45
BFH3CLPO | 300[NAME] unit, full height c/w classic chrome wire pull out | pce | 198.306 | 224.3879999999999 | 232.668 | 235.152 | 244.26
BFH3POD | 300[NAME] unit, full height c/w blum drawer pull out, 2 deep 1 shallow | pce | 320.0219999999999 | 346.518 | 354.384 | 357.2819999999999 | 365.5619999999999
BFH3WGASPO | 300[NAME] unit, full height c/w arena style chrome wire pull out with white shelves | pce | 245.9159999999999 | 271.9979999999999 | 280.278 | 282.348 | 291.456
BFH4 | 400[NAME] single base unit, full height c/w 1 adjustable shelf | pce | 73.27799999999999 | 101.844 | 110.124 | 113.022 | 122.958
[NAME] | 450[NAME] single base unit, full height c/w 1 adjustable shelf | pce | 75.34799999999998 | 105.57 | 114.264 | 117.99 | 127.926
BFH4.5POD | 450[NAME] single base unit, full height c/w blum drawer pull out, 2 deep 1 shallow | pce | 325.818 | 356.454 | 364.734 | 368.0459999999999 | 378.8099999999999
BFH4ACPO | 400[NAME] single base unit, full height c/w arena classic chrome wire pull out | pce | 231.012 | 259.578 | 268.272 | 271.17 | 280.692
BFH4ASPO | 400[NAME] single base unit, full height c/w arena style chrome wire pull out | pce | 254.61 | 283.1759999999999 | 291.8699999999999 | 294.768 | 304.29
BFH4CLPO | 400[NAME] single base unit, full height c/w classic chrome wire pull out | pce | 212.796 | 242.19 | 250.47 | 253.368 | 262.4759999999999
BFH4POD | 400[NAME] single base unit, full height c/w blum drawer pull out, 2 deep 1 shallow | pce | 324.1619999999999 | 352.728 | 361.422 | 363.9059999999999 | 373.8419999999999
BFH4WGASPO | 400[NAME] single base unit, full height c/w arena style chrome wire pull out with white shelves | pce | 270.756 | 299.7359999999999 | 307.602 | 310.9139999999999 | 320.0219999999999
BFH5 | 500[NAME] single base unit, full height c/w 1 adjustable shelf | pce | 77.83199999999998 | 109.296 | 118.818 | 121.716 | 134.136
[NAME] | 500[NAME] single base unit, full height c/w blum drawer pull out, 2 deep 1 shallow | pce | 328.716 | 360.594 | 370.1159999999999 | 372.6 | 385.434
BFH6 | 600[NAME] single base unit, full height c/w 1 adjustable shelf | pce | 81.55799999999998 | 115.92 | 124.614 | 129.582 | 144.9
BFH6POD | 600[NAME] single base unit, full height c/w blum drawer pull out, 2 deep 1 shallow | pce | 332.856 | 367.2179999999999 | 375.9119999999999 | 380.0519999999999 | 395.37
[NAME] | 700mm double base unit, full height c/w 1 adjustable shelf | pce | 96.46199999999997 | 151.524 | 167.67 | 173.466 | 192.096
BFH8 | 800mm double base unit, full height c/w 1 adjustable shelf | pce | 98.946 | 157.32 | 173.88 | 180.09 | 199.962
BFH8POD | 800[NAME] single base unit, full height c/w blum drawer pull out, 2 deep 1 shallow | pce | 352.728 | 398.6819999999999 | 408.204 | 417.3119999999999 | 444.636
BFH9 | 900mm double base unit, full height c/w 1 adjustable shelf | pce | 102.258 | 163.116 | 180.918 | 186.3 | 209.07
BFH9POD | 900mm single base unit, full height c/w blum drawer pull out, 2 deep 1 shallow | pce | 349.4159999999999 | 408.204 | 410.6879999999999 | 427.2479999999999 | 462.4379999999999
BFHD10 | 1000mm double base unit, drop height c/w 1 adjustable shelf | pce | 101.016 | 159.804 | 175.95 | 180.504 | 197.478
BFHD12 | 1200mm double base unit, drop height c/w 1 adjustable shelf | pce | 108.054 | 171.81 | 186.3 | 193.338 | 215.28
BFHD3 | 300[NAME] unit, drop height c/w 1 adjustable shelf | pce | 64.998 | 89.42399999999998 | 96.46199999999997 | 98.11799999999998 | 105.156
BFHD4 | 400[NAME] single base unit, drop height c/w 1 adjustable shelf | pce | 67.89599999999999 | 95.21999999999998 | 102.258 | 104.742 | 110.952
BFHD4.5 | 450[NAME] single base unit, drop height c/w 1 adjustable shelf | pce | 70.79399999999998 | 98.946 | 106.812 | 108.882 | 116.748
BFHD5 | 500[NAME] single base unit, drop height c/w 1 adjustable shelf | pce | 72.44999999999999 | 101.844 | 109.71 | 111.78 | 120.888
BFHD6 | 600[NAME] single base unit, drop height c/w 1 adjustable shelf | pce | 77.00399999999999 | 108.882 | 116.334 | 120.06 | 130.41
BFHD8 | 800mm double base unit, drop height c/w 1 adjustable shelf | pce | 93.564 | 147.798 | 162.288 | 165.6 | 178.848
BFHD9 | 900mm double base unit, drop height c/w 1 adjustable shelf | pce | 96.46199999999997 | 153.18 | 167.67 | 172.6379999999999 | 187.956
BFHHH10 | 1000mm double base unit, 360mm high (doors drilled at 80mm centres) | pce | 93.564 | 148.212 | 163.116 | 167.2559999999999 | 182.988
BFHHH12 | 1200mm double base unit, 360mm high (doors drilled at 80mm centres) | pce | 100.188 | 158.976 | 172.6379999999999 | 178.848 | 199.134
BFHHH3 | 300[NAME] unit, 360mm high (door drilled at 80mm centres) | pce | 60.44399999999999 | 82.8 | 89.42399999999998 | 91.08 | 97.28999999999999
BFHHH4 | 400[NAME] single base unit, 360mm high (door drilled at 80mm centres) | pce | 62.928 | 88.18199999999999 | 94.80599999999998 | 97.28999999999999 | 102.672
BFHHH4.5 | 450[NAME] single base unit, 360mm high (door drilled at 80mm centres) | pce | 65.826 | 91.90799999999997 | 98.946 | 101.016 | 108.054
BFHHH5 | 500[NAME] single base unit, 360mm high (door drilled at 80mm centres) | pce | 67.068 | 94.39199999999997 | 101.844 | 103.5 | 112.194
BFHHH6 | 600[NAME] single base unit, 360mm high (door drilled at 80mm centres) | pce | 71.62199999999999 | 101.016 | 107.64 | 111.366 | 120.888
BFHHH8 | 800mm double base unit, 360mm high (doors drilled at 80mm centres) | pce | 86.93999999999998 | 137.034 | 150.282 | 153.18 | 165.6
BFHHH9 | 900mm double base unit, 360mm high (doors drilled at 80mm centres) | pce | 89.42399999999998 | 142.002 | 155.25 | 159.804 | 173.88
BFHR1.5 | 150mm single base unit, full height, 300 deep c/w 1 adjustable shelf, full top/bot shelf and full height back | pce | 62.09999999999999 | 78.65999999999998 | 84.04199999999999 | 89.83799999999998 | 93.97799999999998
BFHR1.5CLPO | 150[NAME] full height, reduced depth c/w classic chrome wire pull out | pce | 168.498 | 185.886 | 191.268 | 196.65 | 200.79
BFHR10 | 1000mm double base unit, full height, 300 deep c/w 1 adjustable shelf, full top/bot shelf and full height back | pce | 107.226 | 170.568 | 189.198 | 194.58 | 220.662
BFHR12 | 1200mm double base unit, full height, 300 deep c/w 1 adjustable shelf, full top/bot shelf and full height back | pce | 114.264 | 182.574 | 201.204 | 209.898 | 240.948
BFHR2.6 | 260[NAME] single base unit, full height, 300 deep c/w 1 adjustable shelf, full top/bot shelf and full height back | pce | 67.89599999999999 | 93.14999999999999 | 100.602 | 102.672 | 111.366
BFHR3 | 300[NAME] unit, full height, 300 deep c/w 1 adjustable shelf, full top/bot shelf and full height back | pce | 69.55199999999999 | 95.21999999999998 | 104.328 | 106.812 | 115.506
BFHR3.5 | 350[NAME] single base unit, full height, 300 deep c/w 1 adjustable shelf, full top/bot shelf and full height back | pce | 71.62199999999999 | 98.53199999999998 | 107.64 | 110.124 | 119.646
BFHR4 | 400[NAME] single base unit, full height, 300 deep c/w 1 adjustable shelf, full top/bot shelf and full height back | pce | 73.27799999999999 | 101.844 | 110.124 | 113.022 | 122.958
BFHR4.5 | 450[NAME] single base unit, full height, 300 deep c/w 1 adjustable shelf, full top/bot shelf and full height back | pce | 75.34799999999998 | 105.57 | 114.264 | 117.99 | 127.926
BFHR5 | 500[NAME] single base unit, full height, 300 deep c/w 1 adjustable shelf, full top/bot shelf and full height back | pce | 77.83199999999998 | 109.296 | 118.818 | 121.716 | 134.136
BFHR6 | 600[NAME] single base unit, full height, 300 deep c/w 1 adjustable shelf, full top/bot shelf and full height back | pce | 81.55799999999998 | 115.92 | 124.614 | 129.582 | 144.9
BFHR7 | 700mm double base unit, full height, 300 deep c/w 1 adjustable shelf, full top/bot shelf and full height back | pce | 96.46199999999997 | 151.524 | 167.67 | 173.466 | 192.096
BFHR8 | 800mm double base unit, full height, 300 deep c/w 1 adjustable shelf, full top/bot shelf and full height back | pce | 98.946 | 157.32 | 173.88 | 180.09 | 199.962
BFHR9 | 900mm double base unit, full height, 300 deep c/w 1 adjustable shelf, full top/bot shelf and full height back | pce | 102.258 | 163.116 | 180.918 | 186.3 | 209.07
BINCP715 | Internal base corner post with handle cutout, 715x90x90mm | pce | 96.46199999999997 | 96.46199999999997 | 96.46199999999997 | 96.46199999999997 | 96.46199999999997
BOXCANOPY | Primed cooker canopy to house ceiling extractor, primed finish, [NAME]. [NAME] 2000 x 1000 x 300mm (please use template to specify sizes and any radius corners) | pce | 575.8739999999999 | 575.8739999999999 | 575.8739999999999 | 575.8739999999999 | 575.8739999999999
BSB60 | 600mm belfast sink base, 460mm high c/w 1 adjustable shelf | pce | 77.00399999999999 | 105.156 | 110.952 | 114.264 | 122.544
BSB80 | [NAME] belfast sink base, 495mm high c/w 1 adjustable shelf | pce | 94.39199999999997 | 151.11 | 163.116 | 170.154 | 185.886
CAN657 | 600mm canopy hood unit, 575mm high and 300mm deep | pce | 82.8 | 114.264 | 122.13 | 125.028 | 135.792
CAN657D | 600mm canopy hood unit, 575mm high and 350mm deep | pce | 82.8 | 114.264 | 122.13 | 125.028 | 135.792
CAN672 | 600mm canopy hood unit, 720mm high and 300mm deep | pce | 93.14999999999999 | 127.098 | 135.792 | 140.76 | 155.664
CAN672D | 600mm canopy hood unit, 720mm high and 350mm deep | pce | 93.14999999999999 | 127.098 | 135.792 | 140.76 | 155.664
CAN690 | 600mm canopy hood unit, 900mm high and 300mm deep | pce | 105.984 | 146.556 | 155.25 | 160.218 | 180.504
CAN690D | 600mm canopy hood unit, 900mm high and 350mm deep | pce | 105.984 | 146.556 | 155.25 | 160.218 | 180.504
CAN957 | 900mm canopy hood unit, 575mm high and 300mm deep | pce | 111.78 | 168.498 | 182.574 | 188.37 | 203.2739999999999
[NAME] | 900mm canopy hood unit, 575mm high and 350mm deep | pce | 111.78 | 168.498 | 182.574 | 188.37 | 203.2739999999999
CAN972 | 900mm canopy hood unit, 720mm high and 300mm deep | pce | 127.098 | 187.956 | 204.93 | 211.14 | 233.082
CAN972D | 900mm canopy hood unit, 720mm high and 350mm deep | pce | 127.098 | 187.956 | 204.93 | 211.14 | 233.082
CAN990 | 900mm canopy hood unit, 900mm high and 300mm deep | pce | 147.798 | 214.866 | 233.082 | 235.98 | 265.788
CAN990D | 900mm canopy hood unit, 900mm high and 350mm deep | pce | 147.798 | 214.866 | 233.082 | 235.98 | 265.788
CDL10.5/6ACMCU | 1050[NAME] corner base unit, drawerline c/w 600 door and arena classic magic corner unit | pce | 650.3939999999999 | 697.1759999999999 | 713.7359999999998 | 718.7039999999998 | 734.4359999999998
CDL10.5/6ASMCU | 1050[NAME] corner base unit, drawerline c/w 600 door and arena style magic corner unit | pce | 722.0159999999998 | 768.7979999999999 | 784.9439999999998 | 789.9119999999999 | 805.2299999999999
CDL10.5/6CLMCU | 1050[NAME] corner base unit, drawerline c/w 600 door and classic magic corner unit | pce | 581.2559999999999 | 628.0379999999998 | 645.012 | 649.5659999999998 | 665.2979999999999
CDL10.5/6WGASMCU | 1050[NAME] corner base unit, drawerline c/w 600 door and arena style magic corner unit with white shelves | pce | 725.7419999999998 | 772.1099999999999 | 788.2559999999999 | 793.6379999999999 | 808.9559999999999
CDL10/5 | 1000mm corner base unit, drawerline c/w 1 adjustable shelf and 500 door | pce | 166.842 | 210.312 | 227.286 | 231.012 | 243.846
CDL10/5ACLM | 1000mm corner base unit, drawerline c/w 500 door and arena classic le mans corner pull out | pce | 493.4879999999999 | 536.544 | 553.9319999999999 | 557.6579999999999 | 570.0779999999999
CDL10/5ASLM | 1000mm corner base unit, drawerline c/w 500 door and arena style le mans corner pull out | pce | 543.1679999999999 | 586.6379999999999 | 603.612 | 606.924 | 619.7579999999999
CDL10/5ASWGLM | 1000mm corner base unit, drawerline c/w 500 door and arena style le mans corner pull out with white shelves | pce | 584.5679999999999 | 627.6239999999999 | 645.4259999999999 | 648.3239999999998 | 661.1579999999999