Spreadsheet: 673362d1587331981-nested-index-match-formula-copy-of-rebates-spreadsheet-mike-revision-3-
Sheet: Sheet2

Suite |  | Residential | Residential_Width | Residential_Height | Residential_Reveal_Size |  | Fixingtags | Add |  |  |  | ResidentialSizeReveal
Residential |  | Single Slider (projected frame) | 53 | 43 | 43 |  | Yes | 36 |  |  |  | Single Slider (projected frame) | 43
Metro |  | Single Slider (flat face frame) | 100 | 43 | 90 |  | No |  |  |  |  | Single Slider (flat face frame) | 90
Residential_ThermalHEART |  | Duo Slider (projected frame) | 100 | 43 | 90 |  |  |  |  |  |  | Duo Slider (projected frame) | 90
Metro_ThermalHEART |  | Duo Slider (flat face frame) | 151 | 43 | 141 |  |  |  |  |  |  | Duo Slider (flat face frame) | 141
Architectural_Series |  | Triple Slider (No flat face option) | 147 | 46 | 137 |  |  |  |  |  |  | Triple Slider (No flat face option) | 137
 |  | Open Out Door | 53 | 47 | 43 |  | Framing_width |  |  |  |  | Open Out Door | 43
 |  | Open In Door | 53 | 30 | 43 |  | 140 |  |  |  |  | Open In Door | 43
 |  | Window | 53 | 20 | 43 |  | 90 |  |  |  |  | Window | 43
 |  | Metro | Metro_Width | Metro_Height | Metro_Reveal_Size |  |  |  |  |  |  | MetroSizeReveal
 |  | Single Slider | 114 | 40 | 104 |  |  |  |  |  |  | Single Slider | 104
 |  | Duo Slider | 168 | 40 | 158 |  |  |  |  |  |  | Duo Slider | 158
 |  | Open Out Door | 58 | 47 | 48 |  |  |  |  |  |  | Open Out Door | 48
 |  | Open In Door | 58 | 30 | 48 |  |  |  |  |  |  | Open In Door | 48
 |  | Window | 58 | 20 | 48 |  |  |  |  |  |  | Window | 48
 |  | Residential_ThermalHEART | RTH_Width | RTH_Height | RTH_Reveal_Size |  |  |  |  |  |  | Residential_ThermalHEARTSizeReveal
 |  | Single Slider | 108 | 43 | 98 |  |  |  |  |  |  | Single Slider | 98
 |  | Duo Slider | 155 | 43 | 144 |  |  |  |  |  |  | Duo Slider | 144
 |  | Open Out Door | 56 | 53 | 46 |  |  |  |  |  |  | Open Out Door | 46
 |  | Open In Door | 56 | 34 | 46 |  |  |  |  |  |  | Open In Door | 46
 |  | Window | 45 | 35 | 34 |  |  |  |  |  |  | Window | 34
 |  | Metro_ThermalHEART | MTH_Width | MTH_Height | MTH_Reveal_Size |  |  |  |  |  |  | Metro_ThermalHEARTSize Reveal
 |  | Single Slider | 116 | 46 | 106 |  |  |  |  |  |  | Single Slider | 106
 |  | Duo Slider | 170 | 46 | 160 |  |  |  |  |  |  | Duo Slider | 160
 |  | Open Out Door | 69 | 53 | 53 |  |  |  |  |  |  | Open Out Door | 53
 |  | Open In Door | 69 | 20 | 53 |  |  |  |  |  |  | Open In Door | 53
 |  | Window | 53 | 42 | 36 |  |  |  |  |  |  | Window | 36
 |  | Architectural_Series | ARCH_Width | ARCH_Height |  |  |  |  |  |  |  | Architectural Series
 |  | 2  Track Slider | 125 | 64 |  |  |  |  |  |  |  | 2  Track Slider
 |  | 3 Track Slider | 177 | 64 |  |  |  |  |  |  |  | 3 Track Slider
 |  | 4 Track Slider | 229 | 64 |  |  |  |  |  |  |  | 4 Track Slider
 |  | 2 panel Bi-Pass | 125 | 74 |  |  |  |  |  |  |  | 2 panel Bi-Pass
 |  | 3 Panel Bi-Pass | 177 | 74 |  |  |  |  |  |  |  | 3 Panel Bi-Pass
 |  | 106 Open Out Door (Sub Sill) | 125 | 64 |  |  |  |  |  |  |  | 106 Open Out Door (Sub Sill)
 |  | 106 Open In Door  (Sub Sill) | 125 | 64 |  |  |  |  |  |  |  | 106 Open In Door  (Sub Sill)
 |  | 106 Window  (Sub Sill) | 125 | 64 |  |  |  |  |  |  |  | 106 Window  (Sub Sill)
 |  | 106 Open Out Door (Sub Sill) | 177 | 64 |  |  |  |  |  |  |  | 106 Open Out Door (Sub Sill)
 |  | 106 Open In Door  (Sub Sill) | 177 | 64 |  |  |  |  |  |  |  | 106 Open In Door  (Sub Sill)
 |  | 106 Window  (Sub Sill) | 177 | 64 |  |  |  |  |  |  |  | 106 Window  (Sub Sill)