Spreadsheet: 151178d1334823556-vlookup-problem-including-n-a-new-take-off-sheet-test
Sheet: Data

Light Master [NAME] |  |  |  |  |  | System List
LBC5006/10 | [PHONE] | 1 |  |  |  | Light_Master_Modular
LBC5007/00 | [PHONE] | 2 |  |  |  | General_Purpose
LBC5008/10 | [PHONE] | 3 |  |  |  | Trios
LCN5009/00 | [PHONE] | 4 |  |  |  | Occu_Series
LCN8605/38 | [PHONE] | 5 |  |  |  | Scene_Setting
LFC5089/10 | [PHONE] | 6 |  |  |  | [NAME]
LFC5089/20 | [PHONE] | 7
LCNBACOM | [PHONE] | 8 |  |  |  | Leads & Plugs
LCN5232/00 | [PHONE] | 9 |  |  |  | Panels & Additional Products
LRC5914/10 | [PHONE] | 10 |  |  |  | Leading & Trailing Edge Dimming Control
LRC5924/10 | [PHONE] | 11 |  |  |  | Relay Control
LRC5934/10 | [PHONE] | 12 |  |  |  | HFBallastControl
LRC5944/10 | [PHONE] | 13 |  |  |  | EcolinxLCM
LRC5414/10 | [PHONE] | 14 |  |  |  | Multi-PurposeControl-DDMC802&Modules
LRC5423/10 | [PHONE] | 15 |  |  |  | FixtureCouplers
LRC5059/10 | [PHONE] | 16 |  |  |  | SystemIntegration
LRC5141/10 | [PHONE] | 17 |  |  |  | NetworkAcessories
LRC5143/10 | [PHONE] | 18 |  |  |  | Software
LCC5301/00 | [PHONE] | 19 |  |  |  | Sensors
LRC5501/00 | [PHONE] | 20 |  |  |  | Timeclocks
LRC5502/00 |  | 21 |  |  |  | TouchScreens
 |  | 22 |  |  |  | RemoteControls
General Purpose |  | 23 |  |  |  | DR2PE
LRD8000/10 | [PHONE] | 24 |  |  |  | DPNE
LRD8010/10 | [PHONE] | 25 |  |  |  | DPWE
LRD9087/00 | [PHONE] | 26 |  |  |  | DLPE
LRM8114/00 | [PHONE] | 27 |  |  |  | Options - Leading & Trailing Edge Dimmers
LRM8115/00 | [PHONE] | 28 |  |  |  | Options-RelayControllers
LRM8116/00 | [PHONE] | 29 |  |  |  | Options-HFBallastControllers
LRM8117/00 | [PHONE] | 30 |  |  |  | Options-MulitpurposeControllers
LRI8134/00 | [PHONE] | 31
LRL8102/10 | [PHONE] | 32
IRR8125/10 | [PHONE] | 33
LRL1220/05 | [PHONE] | 34
LRL1220/08 | [PHONE] | 35
LCU8020/00 | [PHONE] | 36
LRL5002/10 | [PHONE] | 37
IRT8050/00 | [PHONE] | 38
IRT8055/00 | [PHONE] | 39
IRT8010/00 | [PHONE] | 40
IRT8030/00 | [PHONE] | 41
IRT8040/00 | [PHONE] | 42
IRT8080/00 | [PHONE] | 43
IRT7090/00 | [PHONE] | 44
IRT8080/P | [PHONE] | 45
LRH5100/10 | [PHONE] | 46
LRH8010/00 | [PHONE] | 47
LRH8100/00 | [PHONE] | 48
LCC8011/00 | [PHONE] | 49
LCC8012/00 | [PHONE] | 50
LCC8013/00 | [PHONE] | 51
LCC8014/00 | [PHONE] | 52
LCC8015/00 | [PHONE] | 53
LCC8016/00 | [PHONE] | 54
LCC8016/10 | [PHONE] | 55
LCC8016/20 | [PHONE] | 56
LCC8024/00 | [PHONE] | 57
LCC8025/00 | [PHONE] | 58
 |  | 59
Trios |  | 60
LRC1030/10 | [PHONE] | 61
LRC1035/10 | [PHONE] | 62
LRC1020/20 | [PHONE] | 63
LRC1010/20 | [PHONE] | 64
LRC1015/20 | [PHONE] | 65
 |  | 66
Occu Series |  | 67
LRM1070/00 | [PHONE] | 68
LRM1080/00 | [PHONE] | 69
LRH1070/00 | [PHONE] | 70
LCC1070/00 | [PHONE] | 71
LRM2070/00 | [PHONE] | 72
LCC2070/00 | [PHONE] | 73
LRM2080/00 | [PHONE] | 74
LRM2080/00 | [PHONE] | 75
LRM2090/00 | [PHONE] | 76
LRH2070/00 | [PHONE] | 77
IRT8097/00 | [PHONE] | 78
IRT8099/10 | [PHONE] | 79
 |  | 80
Scene Setting |  | 81
TSU9600 | [PHONE] | 82
TSU9400 | [PHONE] | 83
LXS8806/VC | [PHONE] | 84
LXS8808/VC | [PHONE] | 85
 |  | 86
ColourChaser & DMX Controls |  | 87
LRC9611/00 |  | 88
LRC9610/00 | [PHONE] | 89
LRC9600/00 | [PHONE] | 90
LRC7500/00 | [PHONE] | 91
LCN7211/00 | [PHONE] | 92
LRC7106/00 | [PHONE] | 93
[NAME] | [PHONE] | 94
LCA9109/15 | [PHONE] | 95
LCT7200/00 | [PHONE] | 96
LTC9100/00 | [PHONE] | 97
LCP7706/00 | [PHONE] | 98
 |  | 99
Multidim |  | 100
DCMD444 | [PHONE] | 101
DCMD494 | [PHONE] | 102
DCMD302 | [PHONE] | 103
DCMD303 | [PHONE] | 104
[NAME] | [PHONE] | 105
DCMD400 | [PHONE] | 106
DCMD450 | [PHONE] | 107
DCMD416 |  | 108
DCMD425 |  | 109
DCMD472 |  | 110
DCMD9242 | [PHONE] | 111
[NAME] | [PHONE] | 112
[NAME] | [PHONE] | 113
[NAME] | [PHONE] | 114
DCMD111 | [PHONE] | 115
DCMD121 | [PHONE] | 116
DCMD122 | [PHONE] | 117
DCMD124 | [PHONE] | 118
DCMD125 | [PHONE] | 119
DCMD126 | [PHONE] | 120
DCMD150 | [PHONE] | 121
DCMD170 | [PHONE] | 122
DCMD180 | [PHONE] | 123
DCMD200D | [PHONE] | 124
DCMD200S | [PHONE] | 125
 |  | 126
Leads & Plugs |  | 127
LCC9511/63 | [PHONE] | 128
LCC9511/65 | [PHONE] | 129
LCC9512/63 | [PHONE] | 130
LCC9512/65 | [PHONE] | 131
LCC9513/43 | [PHONE] | 132
LCC9513/45 | [PHONE] | 133
[NAME] | [PHONE] | 134
LCC9515/45 | [PHONE] | 135
LCC9516/33 | [PHONE] | 136
LCC9516/35 | [PHONE] | 137
LCC9517/53 | [PHONE] | 138
[NAME] | [PHONE] | 139
LCC9517/33 | [PHONE] | 140
LCC9517/35 | [PHONE] | 141
[NAME] | [PHONE] | 142
LCC9528/30 | [PHONE] | 143
LCC9531/20 | [PHONE] | 144
LCC9531/21 | [PHONE] | 145
LCA9532/30 | [PHONE] | 146
LCA9533/20 | [PHONE] | 147
LCC9526/40 | [PHONE] | 148
 |  | 149
Panels & Additional Products |  | 150
LCP5780/TSA | [PHONE] | 151
 |  | 152
Dynalite |  | 153
LoadControllers |  | 154
Leading&TrailingEdgeDimmingControl |  | 155
[NAME] | [PHONE] | 156
[NAME] | [PHONE] | 157
DLE120-S | [PHONE] | 158
DLE220-S | [PHONE] | 159
DTE310 | [PHONE] | 160
DLE405 | [PHONE] | 161
DLE405-NB | [PHONE] | 162
DLE410 | [PHONE] | 163
DLE1203 | [PHONE] | 164
DLE1205 | [PHONE] | 165
DLE1210 | [PHONE] | 166
DLE1210GL | [PHONE] | 167
DTE1210 | [PHONE] | 168
DLE1220GL-S | [PHONE] | 169
 |  | 170
RelayControl |  | 171
DDRC420FR | [PHONE] | 172
DDRC810 | [PHONE] | 173
DDRC810DT | [PHONE] | 174
DDRC820FR | [PHONE] | 175
DDRC1220FR-GL | [PHONE] | 176
DRC810DT | [PHONE] | 177
DRC1205 | [PHONE] | 178
DRC1210 | [PHONE] | 179
DRC1220 |  | 180
 |  | 181
HFBallastControl |  | 182
DDBC100-DALI | [PHONE] | 183
DDBC300-DALI | [PHONE] | 184
DDBC320-DALI | [PHONE] | 185
DDBC1200 | [PHONE] | 186
DDBC1200-MO | [PHONE] | 187
DBC410 | [PHONE] | 188
DBC1205 | [PHONE] | 189
DBC1210 | [PHONE] | 190
[NAME] |  | 191
EcolinxLCM |  | 192
DBC905W | [PHONE] | 193
DBC905C | [PHONE] | 194
DYNET-SFALT6-CABLE-10m | [PHONE] | 195
DYNET-SFALT6-CABLE-05m | [PHONE] | 196
DYNET-SFALT6-CABLE-03m | [PHONE] | 197
625-379 |  | 198
625-375 |  | 199
625-373 |  | 200
625-372 |  | 201
Multi-Purpose Control |  | 202
DDMC802 | [PHONE] | 203
DDMC802-MO | [PHONE] | 204
DDLM102 | [PHONE] | 205
DDLM104 | [PHONE] | 206
DDTM102 | [PHONE] | 207
DDBM100 | [PHONE] | 208
DDRM104 | [PHONE] | 209
DDCM102 | [PHONE] | 210
DDFM102 | [PHONE] | 211
FFC-PRO |  | 212
DDMC802GL |  | 213
DGLM402 | [PHONE] | 214
[NAME] | [PHONE] | 215
DGBM200 | [PHONE] | 216
DGRM204 | [PHONE] | 217
DGLM105 | [PHONE] | 218
DGTM105 | [PHONE] | 219
DGCM102 | [PHONE] | 220
DGFM102 | [PHONE] | 221
[NAME] | [PHONE] | 222
 |  | 223
FixtureCouplers |  | 224
DMBC110 | [PHONE] | 225
DMRC210 | [PHONE] | 226
 |  | 227
SystemIntegration |  | 228
DIR-TX8 |  | 229
DIR-EM2 |  | 230
DLP800 |  | 231
DMNG100BT | [PHONE] | 232
DMNG232 | [PHONE] | 233
DPMI940 | [PHONE] | 234
DDFCUC024 | [PHONE] | 235
DDMIDC8 | [PHONE] | 236
DDNG485 | [PHONE] | 237
DDNIBACNET |  | 238
DDNG100BT |  | 239
DDNI485 | [PHONE] | 240
DDNI-LON |  | 241
DNG100BT | [PHONE] | 242
DAC100BT | [PHONE] | 243
DNG232 | [PHONE] | 244
DNG485 | [PHONE] | 245
 |  | 246
NetworkAcessories |  | 247
200-117 |  | 248
DDNP1501 | [PHONE] | 249
DPP601 | [PHONE] | 250
DTK622-USB | [PHONE] | 251
Software |  | 252
DTK624-PACK | [PHONE] | 253
DL3SBL | SW913703092009 | 254
DL3SUL | SW913703092209 | 255
DL3MVBL | SW913703092309 | 256
Sensors |  | 257
DUS804C | [PHONE] | 258
DUS804RJ | [PHONE] | 259
DUS804C-UP |  | 260
DUS704W | [PHONE] | 261
DUS704C | [PHONE] | 262
DTS900 | [PHONE] | 263
DTS900M | [PHONE] | 264
 |  | 265
Timeclocks |  | 266
DDTC001 | [PHONE] | 267
DTCE602 | [PHONE] | 268
 |  | 269
TouchScreens |  | 270
DTP100 | [PHONE] | 271
DTP100-WG | [PHONE] | 272
DTP100-BG | [PHONE] | 273
DTP170 | [PHONE] | 274
DTP170-WALLBOX | [PHONE] | 275
DTK600 | [PHONE] | 276
DTK600-SS | [PHONE] | 277
280-164 |  | 278
280-165 |  | 279
DTK600-ENCLOSURE | [PHONE] | 280
 |  | 281
RemoteControls |  | 282
DTK504 | [PHONE] | 283
DTK506 | [PHONE] | 284
DTK508 | [PHONE] | 285
DTK510 | [PHONE] | 286
DTK512 | [PHONE] | 287
UserControlPanels-UK/EuropeanMountingConfiguration |  | 288
 |  | 289
DR2PERevolutionSeries2 |  | 290
 |  | 291
StainlessSteel |  | 292
DR2PE91A-CSS-ENG | [PHONE] | 293
DR2PE92C-CSS-ENG | [PHONE] | 294
DR2PE97L-CSS-ENG | [PHONE] | 295
DR2PE98M-CSS-ENG | [PHONE] | 296
DR2PE97L8M-CSS-ENG | [PHONE] | 297
DR2PE91A-SSS-ENG | [PHONE] | 298
DR2PE92C-SSS-ENG | [PHONE] | 299
DR2PE97L-SSS-ENG | [PHONE] | 300
DR2PE98M-SSS-ENG | [PHONE] | 301
DR2PE97L8M-SSS-ENG | [PHONE] | 302
WhiteBorosilicateGlass |  | 303
DR2PE91A-CWG-ENG | [PHONE] | 304
DR2PE92C-CWG-ENG | [PHONE] | 305
DR2PE97L-CWG-ENG | [PHONE] | 306
DR2PE98M-CWG-ENG | [PHONE] | 307
DR2PE97L8M-CWG-ENG | [PHONE] | 308
DR2PE91A-SWG-ENG | [PHONE] | 309
DR2PE92C-SWG-ENG | [PHONE] | 310
DR2PE97L-SWG-ENG | [PHONE] | 311
DR2PE98M-SWG-ENG | [PHONE] | 312
DR2PE97L8M-SWG-ENG | [PHONE] | 313
BlackBorosilicateGlass |  | 314
DR2PE91A-CBG-ENG | [PHONE] | 315
DR2PE92C-CBG-ENG | [PHONE] | 316
DR2PE97L-CBG-ENG | [PHONE] | 317
DR2PE98M-CBG-ENG | [PHONE] | 318
DR2PE97L8M-CBG-ENG | [PHONE] | 319
DR2PE91A-SBG-ENG | [PHONE] | 320
DR2PE92C-SBG-ENG | [PHONE] | 321
DR2PE97L-SBG-ENG | [PHONE] | 322
DR2PE98M-SBG-ENG | [PHONE] | 323
DR2PE97L8M-CWG-ENG | [PHONE] | 324
 |  | 325
 |  | 326
 |  | 327
 |  | 328
 |  | 329
 |  | 330
 |  | 331
 |  | 332
 |  | 333
DPNE-SFSeries-ScrewlessFixingStandardLinishedStainlessSteelFinish,SilverButtons&BlackBezels |  | 334
9SeriesConfigurable |  | 335
DPNE308N-SF |  | 336
DPNE914-SF |  | 337
[NAME] |  | 338
[NAME] |  | 339
DPNE963-SF |  | 340
DPNE981-SF |  | 341
DPNE981DN-SF |  | 342
DPNE982-SF |  | 343
DPNE982D-SF |  | 344
DPNE9103-SF |  | 345
DPNE9121-SF |  | 346
DPNE9122-SF |  | 347
DPNE9161-SF |  | 348
 |  | 349
DPNE&DPNE-SFCustomEngravedButtonCaps |  | 350
270-086 |  | 351
270-087 |  | 352
270-091 |  | 353
270-088 |  | 354
270-089 |  | 355
270-092 |  | 356
DPWESeries-Grid&Buttonassemblywithcover,buttons&bezels |  | 357
9SeriesConfigurable |  | 358
StainlessSteelCovers |  | 359
DPWE910-CH-SS-ENG | [PHONE] | 360
DPWE920-CH-SS-ENG | [PHONE] | 361
DPWE950-CH-SS-ENG | [PHONE] | 362
DPWE960-CH-SS-ENG | [PHONE] | 363
DPWE970-CH-SS-ENG | [PHONE] | 364
DPWE9100-CH-SS-ENG1 | [PHONE] | 365
DPWE9100-CH-SS-ENG2 | [PHONE] | 366
DPWE910-WE-SS-ENG | [PHONE] | 367
DPWE920-WE-SS-ENG | [PHONE] | 368
DPWE950-WE-SS-ENG | [PHONE] | 369
DPWE960-WE-SS-ENG | [PHONE] | 370
DPWE970-WE-SS-ENG | [PHONE] | 371
DPWE9100-WE-SS-ENG1 | [PHONE] | 372
DPWE9100-WE-SS-ENG2 | [PHONE] | 373
PolishedBrassCovers |  | 374
DPWE910-CH-PB-ENG | [PHONE] | 375
DPWE920-CH-PB-ENG | [PHONE] | 376
DPWE950-CH-PB-ENG | [PHONE] | 377
DPWE960-CH-PB-ENG | [PHONE] | 378
DPWE970-CH-PB-ENG | [PHONE] | 379
DPWE9100-CH-PB-ENG1 | [PHONE] | 380
DPWE9100-CH-PB-ENG2 | [PHONE] | 381
DPWE910-WE-PB-ENG | [PHONE] | 382
DPWE920-WE-PB-ENG | [PHONE] | 383
DPWE950-WE-PB-ENG | [PHONE] | 384
DPWE960-WE-PB-ENG | [PHONE] | 385
DPWE970-WE-PB-ENG | [PHONE] | 386
DPWE9100-WE-PB-ENG1 | [PHONE] | 387
DPWE9100-WE-PB-ENG2 | [PHONE] | 388
WhiteCovers |  | 389
DPWE910-CH-W-ENG | [PHONE] | 390
DPWE920-CH-W-ENG | [PHONE] | 391
DPWE950-CH-W-ENG | [PHONE] | 392
DPWE960-CH-W-ENG | [PHONE] | 393
DPWE970-CH-W-ENG | [PHONE] | 394
DPWE9100-CH-W-ENG1 | [PHONE] | 395
DPWE9100-CH-W-ENG2 | [PHONE] | 396
DPWE910-WE-W-ENG | [PHONE] | 397
DPWE920-WE-W-ENG | [PHONE] | 398
DPWE950-WE-W-ENG | [PHONE] | 399
DPWE960-WE-W-ENG | [PHONE] | 400
DPWE970-WE-W-ENG | [PHONE] | 401
DPWE9100-WE-W-ENG1 | [PHONE] | 402
DPWE9100-WE-W-ENG2 | [PHONE] | 403
 |  | 404
 |  | 405
 |  | 406
 |  | 407
 |  | 408
DLPESeries-StandardStainlessSteelFinish,CharcoalGreyButtons&Bezels |  | 409
9SeriesConfigurable |  | 410
DLPE910 | [PHONE] | 411
DLPE920 | [PHONE] | 412
DLPE950 | [PHONE] | 413
DLPE960 | [PHONE] | 414
DLPE970 | [PHONE] | 415
DLPE9100 | [PHONE] | 416
DLPE&DPWEButton&Engraving |  | 417
LSP-SW-IR |  | 418
LSP-SW-CH-? |  | 419
LSP-SW-WE-? |  | 420
LSP-ENG-WE |  | 421
LSP-ENG-CH |  | 422
LSP-ENG-IR |  | 423
 |  | 424
Options - Leading & Trailing Edge Dimmers |  | 425
 |  | 426
DLE120-S-110V |  | 427
DLE120-S-A |  | 428
 |  | 429
DTE310-3Pole |  | 430
DTE310-ND |  | 431
DTE310-DP |  | 432
 |  | 433
DTK220-110V |  | 434
DTK220-ND |  | 435
DTK220toDTK140 |  | 436
 |  | 437
DLE405-110V |  | 438
DLE405-A | [PHONE] | 439
DLE405-BT | [PHONE] | 440
DLE405-ND | [PHONE] | 441
 |  | 442
DLE410-10KA |  | 443
DLE410-110V |  | 444
DLE410-A | [PHONE] | 445
DLE410-BP | [PHONE] | 446
DLE410-BT | [PHONE] | 447
DLE410-RCBO | [PHONE] | 448
DLE410-DP | [PHONE] | 449
DLE410-SI |  | 450
DLE410-SR |  | 451
 |  | 452
DLE1203-110V |  | 453
DLE1203-A | [PHONE] | 454
DLE1203-BT | [PHONE] | 455
DLE1203-ND | [PHONE] | 456
 |  | 457
DLE1205-110V |  | 458
DLE1205-3Pole | [PHONE] | 459
DLE1205-A | [PHONE] | 460
DLE1205-BP |  | 461
DLE1205-BT | [PHONE] | 462
DLE1205-ND | [PHONE] | 463
DLE1205-RCBO | [PHONE] | 464
DLE1205-SI |  | 465
DLE1205-SR |  | 466
DLE1205-SR3 |  | 467
 |  | 468
DLE1210-10KA |  | 469
DLE1210-110V |  | 470
DLE1210-3Pole |  | 471
DLE1210-3Pole-RCBO |  | 472
DLE1210-A | [PHONE] | 473
DLE1210-BP |  | 474
DLE1210-BT | [PHONE] | 475
DLE1210-DP | [PHONE] | 476
DLE1210-DELTA |  | 477
DLE1210-HR |  | 478
DLE1210-RCBO | [PHONE] | 479
DLE1210-SI | [PHONE] | 480
DLE1210-SR | [PHONE] | 481
DLE1210-SR3 |  | 482
 |  | 483
DLE1220GL-S-10KA |  | 484
DLE1220GL-S-110V |  | 485
DLE1220GL-S-3Pole |  | 486
DLE1220GL-S-A | [PHONE] | 487
DLE1220GL-S-BP |  | 488
DLE1220GL-S-BT | [PHONE] | 489
DLE1220GL-S-DP | [PHONE] | 490
DLE1210-DELTA |  | 491
DLE1220GL-S-RCBO | [PHONE] | 492
DLE1220GL-S-SI | [PHONE] | 493
DLE1220GL-S-SR |  | 494
DLE1220GL-S-SR3 |  | 495
 |  | 496
Options-RelayControllers |  | 497
 |  | 498
DDRC410FR-110V |  | 499
 |  | 500
DDRC620FR-110V |  | 501
 |  | 502
DDRC810-110V |  | 503
 |  | 504
DDRC810DT-110V |  | 505
 |  | 506
DDRC820FR-110V |  | 507
DDRC820FR-BT |  | 508
 |  | 509
DDRC1210FR-110V |  | 510
 |  | 511
DRC810DT-110V |  | 512
DRC810DT-A |  | 513
 |  | 514
DRC1205-110V |  | 515
DRC1205-A | [PHONE] | 516
DRC1205-BT | [PHONE] | 517
DRC1205-ND | [PHONE] | 518
 |  | 519
DRC1210-10KA |  | 520
DRC1210-110V |  | 521
DRC1210-3Pole |  | 522
DRC1210-A |  | 523
DRC1210-BT |  | 524
DRC1210-ND |  | 525
 |  | 526
DRC1220-10KA |  | 527
DRC1220-110V |  | 528
DRC1220-3Pole |  | 529
DRC1220-A | [PHONE] | 530
DRC1220-BT | [PHONE] | 531
DRC1220-ND | [PHONE] | 532
 |  | 533
Options-HFBallastControllers |  | 534
 |  | 535
DBC410-10KA |  | 536
DBC410-110V |  | 537
DBC410-A | [PHONE] | 538
DBC410-BT | [PHONE] | 539
DBC410-DP |  | 540
DBC410-ND | [PHONE] | 541
 |  | 542
DBC1205-A | [PHONE] | 543
 |  | 544
DBC1210-10KA |  | 545
DBC1210-110V |  | 546
DBC1210-A | [PHONE] | 547
DBC1210-BT | [PHONE] | 548
DBC1210-ND | [PHONE] | 549
 |  | 550
DBC1220-10KA |  | 551
DBC1220-110V |  | 552
DBC1220-A |  | 553
[NAME] |  | 554
DBC1220-ND |  | 555
 |  | 556
Options-MulitpurposeControllers |  | 557
 |  | 558
DDMC801-110V |  | 559
 |  | 560
DMC805-110V |  | 561
DMC805-A |  | 562
DMC805-BT |  | 563
DMC805-ND |  | 564