Spreadsheet: 799617d1665157855-dynamic-drop-down-with-different-configuration-of-products-dropdown-sheet
Sheet: Sheet2

Fixture | QTY>100 | Voltage | QTY>100 | Beam Spread | QTY>100 | COB | CRI | [NAME] | QTY>100 | CCT | QTY>100 | QTY>100 | Finish | QTY>100 | Mount | QTY>100 | Option 1 | QTY>100 | Option 2 | QTY>100 |  | LCS | LCN | LCM |  | LCS | LCN | LCM
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19 | Column20 | Column21 |  | VNSP | NSP | NSP |  | 1 | 1 | 1
LCS | 7.65 | 1 | 4.64 | VNSP | 1.36 | CXM-3 |  |  |  | 22 | 0 | 0 | PW | 0 | J | 2.97 | TR | 0.92 | HL | 0.41 |  | NSP | NFL | NFL |  | 2 |  | 2
 |  | 2 | 5.4 | NSP | 1.36 |  | 8 | 600 | 0.87 | 25 | 0 | 0 | BK | 0 | H | 2.97 | SN | 1.53 | LS | 0.24 |  | SP | FL | FL
 |  |  |  | SP | 1.12 |  | 9 | 600 | 0.87 | 27 | 0 | 0 | SV | 0 | L | 2.97 |  |  |  |  |  | NFL | WFL | WFL
 |  |  |  | NFL | 1.43 |  | H | 600 | 0.87 | 30 | 0 | 0 | [NAME] | ？ | CM | 3.3 |  |  |  |  |  | FL
 |  |  |  | FL | 1.17 | 024Z | M (Rs075) |  | 10.45 | 35 | 0 | 0 | BZ | ？ | G-TEK100 | 13.46 |  |  |  |  |  | WFL
 |  |  |  | WFL | 1.59 |  | 8 | 900/1200/1600 | 8.04 | 40 | 0 |  | CR | 1.9 | G-9219-2 | 13.94
 |  |  |  |  |  |  | 9 | 900/1200/1600 | 8.2 | 50 | 0 |  | BA | ？ | [NAME] | 3.92 |  |  |  |  |  | LCS | LCN | LCM
 |  |  |  |  |  |  | H (R9580) | sm303 | 8.6 |  |  |  | GC | 2.75 | GX | ？ |  |  |  |  |  | CXM-3 | CXM-3 | 024Z
 |  |  |  |  |  |  | H (R9580) | sm302 | 9.34 |  |  |  |  |  |  |  |  |  |  |  |  | 024Z |  | 048B
 |  |  |  |  |  | Osram | D27 | 1000 | 3.35 |  |  |  | BC | 2.27 |  |  |  |  |  |  |  | Osram
 |  |  |  |  |  | 036B | M (Rs075) | 1200/1600 | 3.42 |  |  |  | RC | 2.75 |  |  |  |  |  |  |  | 036B
 |  |  |  |  |  |  | 8 | 900/1200/1600 | 2.78
 |  |  |  |  |  |  | 9 | 900/1200/1600 | 2.92
 |  |  |  |  |  |  | H (R9580) | sm302 | 3.18
Fixture | QTY>100 | Voltage | QTY>100 | Beam Spread | QTY>100 | COB | CRI | QTY>100 | CCT | QTY>100 | [NAME] | QTY>100 | Finish | QTY>100 | Mount | QTY>100 | Option 1 | QTY>100 | Option 2 | QTY>100
LCN | 6.1 | 1 | 3.95 | NSP | 1.3 | CXM-3 | 8 | 0.87 | 22 | 0 | 700 |  | PW | 0 | J | 2.97 | TR | 0.7 | HL | 0.41
 |  |  |  | NFL | 1.3 |  | 9 | 0.87 | 25 | 0 |  |  | BK | 0 | H | 2.7 | SN | 1.3 | LS | 0.24
 |  |  |  | FL | 1.12 |  | H | 0.87 | 27 | 0 |  |  | SV | 0 | L | 2.97
 |  |  |  | WFL |  |  |  |  | 30 | 0 |  |  | [NAME] | ？ | CM | 3.3
 |  |  |  |  |  |  |  |  | 35 | 0 |  |  | BZ | ？ | G-TEK100 | 13.46
 |  |  |  |  |  |  |  |  | 40 | 0 |  |  | CR | ？ | G-9219-2 | 13.94
 |  |  |  |  |  |  |  |  | 50 | 0 |  |  | BA | ？ | [NAME] | 3.92
 |  |  |  |  |  |  |  |  |  |  |  |  | GC | ？ | GX | ？
 |  |  |  |  |  |  |  |  |  |  |  |  | BC | ？
 |  |  |  |  |  |  |  |  |  |  |  |  | RC | ？
Fixture | QTY>100 | Voltage | QTY>100 | Beam Spread | QTY>100 | COB | CRI | QTY>100 | [NAME] | CCT | QTY>100 | [NAME] | QTY>100 | Finish | QTY>100 | Mount | QTY>100 | Option 1 | QTY>100 | Option 2 | QTY>100
LCM | 10.5 | 1 | 5.6 | NSP | ？ | 024Z | M | 10.45 |  | 22 | 0 | 1800 | 0 | PW | 0 | J | 2.97 | TR | 1.65 | HL | 0.41
 |  | 2 | 6.4 | NFL | 1.43 |  | 8 | 8.04 | 2300 | 25 | 0 | 2000 | 0 | BK | 0 | H | 2.97 | SN | 2.5 | LC | 0.41
 |  |  |  | FL | 1.17 |  | 9 | 8.2 |  | 27 | 0 | 2300 | 0 | SV | 0 | L | 2.97
 |  |  |  | WFL | 1.59 |  | H | 9.43 |  | 30 | 0 |  |  | [NAME] | ？ | CM | 3.3 |  | -0.85
 |  |  |  |  |  | 048B | M | 4.95 |  | 35 | 0 |  |  | BZ | ？ | G-TEK100 | 13.46
 |  |  |  |  |  |  | 8 | 3.72 | 2000/2300 | 40 | 0 |  |  | CR | ？ | G-9219-2 | 13.94
 |  |  |  |  |  |  | 9 | 4.58 | 2000/2300 | 50 | 0 |  |  | BA | ？ | [NAME] | 3.92
 |  |  |  |  |  |  | H | 5.65 |  |  |  |  |  | GC | ？ | GX | ？
 |  |  |  |  |  |  | 95 | 5.65 |  |  |  |  |  | BC | ？
 |  |  |  |  |  |  |  |  |  |  |  |  |  | RC | ？
 |  |  |  |  |  |  | M | 5.5
 |  |  |  |  |  |  | 8 | 4.32
 |  |  |  |  |  |  | 9 | 3.62
 |  |  |  |  |  |  | H | 3.78