Dependent Drop Down or Other Advanced Solution

IESEnergy

New Member
Joined
Aug 28, 2017
Messages
14
I am having trouble with this dependent drop down. My Wattage sheet is my master table. My ADD sheet is where I want to add the information. I would like to be able to have only the items listed in the other categories be available in my drop down on the ADD sheet. For example, if I choose CFL Fixture then I only want the the three types of subcategories to show.

Even better would be where I could choose the lamp wattage in column E then only those type of fixtures would be available to choose in the Column B, C, and D and vice versa. Is this possible?

Here is a link to the file: http://s000.tinyupload.com/index.php?file_id=23805702498562756109

Master Table

ABCDEFGHIJKLMNO

<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]Order[/TD]
[TD="align: center"]Lighting Category[/TD]
[TD="align: center"]Lighting Subcategory[/TD]
[TD="align: center"]# of Lamps per Fixture[/TD]
[TD="align: center"]Lamp Wattage[/TD]
[TD="align: center"]Fixture Wattage[/TD]
[TD="align: center"]Lamp Type[/TD]
[TD="align: center"]FIXTURE Type[/TD]
[TD="align: center"]FIXTURE CODE[/TD]
[TD="align: center"]LAMP CODE[/TD]
[TD="align: center"]DESCRIPTION[/TD]
[TD="align: center"]BALLAST[/TD]
[TD="align: center"]LAMP / FIXT[/TD]
[TD="align: center"]WATT / LAMP[/TD]
[TD="align: center"]WATT / FIXT[/TD]

[TD="align: center"]15[/TD]
[TD="align: center"]14[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]26[/TD]
[TD="align: center"]162[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CF26/6-L[/TD]
[TD="align: center"]CF26W[/TD]
[TD="align: center"]Compact Fluorescent, (6) 26W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]26[/TD]
[TD="align: center"]162[/TD]

[TD="align: center"]21[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]228[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CF32/6-L[/TD]
[TD="align: center"]CF32W[/TD]
[TD="align: center"]Compact Fluorescent, (6) 32W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]228[/TD]

[TD="align: center"]29[/TD]
[TD="align: center"]28[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]42[/TD]
[TD="align: center"]282[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CF42/6-L[/TD]
[TD="align: center"]CF42W[/TD]
[TD="align: center"]Compact Fluorescent, (6) 42W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]42[/TD]
[TD="align: center"]282[/TD]

[TD="align: center"]57[/TD]
[TD="align: center"]56[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]26[/TD]
[TD="align: center"]150[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFQ26/6-L[/TD]
[TD="align: center"]CFQ26W[/TD]
[TD="align: center"]Compact Fluorescent, quad, (6) 26W lamp, BF=0.95[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]26[/TD]
[TD="align: center"]150[/TD]

[TD="align: center"]82[/TD]
[TD="align: center"]81[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]186[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT32/6-L[/TD]
[TD="align: center"]CFM32W[/TD]
[TD="align: center"]Compact Fluorescent, twin or multi, (6) 32W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]186[/TD]

[TD="align: center"]85[/TD]
[TD="align: center"]84[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]36[/TD]
[TD="align: center"]212[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT36/6-BX[/TD]
[TD="align: center"]CFT36W[/TD]
[TD="align: center"]Compact Fluorescent, Biax, (6) 36W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]36[/TD]
[TD="align: center"]212[/TD]

[TD="align: center"]86[/TD]
[TD="align: center"]85[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]36[/TD]
[TD="align: center"]198[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT36/6-L[/TD]
[TD="align: center"]CFT36W[/TD]
[TD="align: center"]Compact Fluorescent, long Twin, (6) 36W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]36[/TD]
[TD="align: center"]198[/TD]

[TD="align: center"]87[/TD]
[TD="align: center"]86[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]36[/TD]
[TD="align: center"]210[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT36/6-LH[/TD]
[TD="align: center"]CFT36W[/TD]
[TD="align: center"]Compact Fluorescent, long Twin, (6) 36W lamp/ High Ballast Factor[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]36[/TD]
[TD="align: center"]210[/TD]

[TD="align: center"]104[/TD]
[TD="align: center"]103[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]204[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT40/6-BX[/TD]
[TD="align: center"]CFT40W[/TD]
[TD="align: center"]Compact Fluorescent, Biax, (6) 40W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]204[/TD]

[TD="align: center"]105[/TD]
[TD="align: center"]104[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]220[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT40/6-L[/TD]
[TD="align: center"]CFT40W[/TD]
[TD="align: center"]Compact Fluorescent, long Twin, (6) 40W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]220[/TD]

[TD="align: center"]106[/TD]
[TD="align: center"]105[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]233[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT40/6-LH[/TD]
[TD="align: center"]CFT40W[/TD]
[TD="align: center"]Compact Fluorescent, long Twin, (6) 40W lamp/ High Ballast Factor[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]233[/TD]

[TD="align: center"]119[/TD]
[TD="align: center"]118[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]324[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT50/6-BX[/TD]
[TD="align: center"]CFT50W[/TD]
[TD="align: center"]Compact Fluorescent, Biax, (6) 50W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]324[/TD]

[TD="align: center"]128[/TD]
[TD="align: center"]127[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]336[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT55/6-BX[/TD]
[TD="align: center"]CFT55W[/TD]
[TD="align: center"]Compact Fluorescent, Biax, (6) 55W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]336[/TD]

[TD="align: center"]129[/TD]
[TD="align: center"]128[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]352[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT55/6-L[/TD]
[TD="align: center"]CFT55W[/TD]
[TD="align: center"]Compact Fluorescent, long Twin, (6) 55W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]352[/TD]

[TD="align: center"]130[/TD]
[TD="align: center"]129[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]373[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT55/6-LH[/TD]
[TD="align: center"]CFT55W[/TD]
[TD="align: center"]Compact Fluorescent, long Twin, (6) 55W lamp/ High Ballast Factor[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]373[/TD]

[TD="align: center"]259[/TD]
[TD="align: center"]265[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]153[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F26SE[/TD]
[TD="align: center"]F20T12[/TD]
[TD="align: center"]Fluorescent, (6) 24", STD lamp[/TD]
[TD="align: center"]Mag-ES[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]153[/TD]

[TD="align: center"]260[/TD]
[TD="align: center"]266[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]168[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F26SS[/TD]
[TD="align: center"]F20T12[/TD]
[TD="align: center"]Fluorescent, (6) 24", STD lamp[/TD]
[TD="align: center"]Mag-STD[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]168[/TD]

[TD="align: center"]327[/TD]
[TD="align: center"]333[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"]198[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F36EE[/TD]
[TD="align: center"]F30T12/ES[/TD]
[TD="align: center"]Fluorescent, (6) 36", ES lamp[/TD]
[TD="align: center"]Mag-ES[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"]198[/TD]

[TD="align: center"]328[/TD]
[TD="align: center"]334[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T8 Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"]134[/TD]
[TD="align: center"]T8[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F36ILL-R[/TD]
[TD="align: center"]F25T8[/TD]
[TD="align: center"]Fluorescent, (6) 36", T-8 lamp, Instant Start Ballast, RLO (BF<.85)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"]134[/TD]

[TD="align: center"]329[/TD]
[TD="align: center"]335[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]30[/TD]
[TD="align: center"]238[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F36SE[/TD]
[TD="align: center"]F30T12[/TD]
[TD="align: center"]Fluorescent, (6) 36", STD lamp[/TD]
[TD="align: center"]Mag-ES[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]30[/TD]
[TD="align: center"]238[/TD]

[TD="align: center"]331[/TD]
[TD="align: center"]514[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T5HO Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]54[/TD]
[TD="align: center"]351[/TD]
[TD="align: center"]T5[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46GHL[/TD]
[TD="align: center"]F48T5/HO[/TD]
[TD="align: center"]Fluorescent, (6) 48", STD HO T5 lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]54[/TD]
[TD="align: center"]351[/TD]

[TD="align: center"]406[/TD]
[TD="align: center"]656[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T5HO Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]54[/TD]
[TD="align: center"]364[/TD]
[TD="align: center"]T5[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46GHL-H[/TD]
[TD="align: center"]F54T5/HO[/TD]
[TD="align: center"]Fluorescent, (6) 48", STD HO T5 lamp HLO (BF: .96-1.2)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]54[/TD]
[TD="align: center"]364[/TD]

[TD="align: center"]501[/TD]
[TD="align: center"]507[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]34[/TD]
[TD="align: center"]216[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46EE[/TD]
[TD="align: center"]F40T12/ES[/TD]
[TD="align: center"]Fluorescent, (6) 48", ES lamp[/TD]
[TD="align: center"]Mag-ES[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]34[/TD]
[TD="align: center"]216[/TD]

[TD="align: center"]502[/TD]
[TD="align: center"]508[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]34[/TD]
[TD="align: center"]186[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46EL[/TD]
[TD="align: center"]F40T12/ES[/TD]
[TD="align: center"]Fluorescent, (6) 48", ES lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]34[/TD]
[TD="align: center"]186[/TD]

[TD="align: center"]503[/TD]
[TD="align: center"]509[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]34[/TD]
[TD="align: center"]236[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46ES[/TD]
[TD="align: center"]F40T12/ES[/TD]
[TD="align: center"]Fluorescent, (6) 48", ES lamp[/TD]
[TD="align: center"]Mag-STD[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]34[/TD]
[TD="align: center"]236[/TD]

[TD="align: center"]505[/TD]
[TD="align: center"]511[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T8 Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]175[/TD]
[TD="align: center"]T8[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46ILL[/TD]
[TD="align: center"]F32T8[/TD]
[TD="align: center"]Fluorescent, (6) 48", T-8 lamp, Instant Start Ballast, NLO (BF: .85-.95)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]175[/TD]

[TD="align: center"]506[/TD]
[TD="align: center"]512[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T8 Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]156[/TD]
[TD="align: center"]T8[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46ILL-R[/TD]
[TD="align: center"]F32T8[/TD]
[TD="align: center"]Fluorescent, (6) 48", T-8 lamp, Instant Start Ballast, RLO (BF< .85)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]156[/TD]

[TD="align: center"]507[/TD]
[TD="align: center"]513[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T8 Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]182[/TD]
[TD="align: center"]T8[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46LL[/TD]
[TD="align: center"]F32T8[/TD]
[TD="align: center"]Fluorescent, (6) 48", T-8 lamp, NLO (BF: .85-.95)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]182[/TD]

[TD="align: center"]509[/TD]
[TD="align: center"]515[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]258[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46SE[/TD]
[TD="align: center"]F40T12[/TD]
[TD="align: center"]Fluorescent, (6) 48", STD lamp[/TD]
[TD="align: center"]Mag-ES[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]258[/TD]

[TD="align: center"]510[/TD]
[TD="align: center"]516[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]282[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46SS[/TD]
[TD="align: center"]F40T12[/TD]
[TD="align: center"]Fluorescent, (6) 48", STD lamp[/TD]
[TD="align: center"]Mag-STD[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]282[/TD]

[TD="align: center"]554[/TD]
[TD="align: center"]510[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown HO[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]405[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46EHS[/TD]
[TD="align: center"]F48T12/HO/ES[/TD]
[TD="align: center"]Fluorescent, (6) 48", ES HO lamp (3.5' lamp)[/TD]
[TD="align: center"]Mag-STD[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]405[/TD]

[TD="align: center"]635[/TD]
[TD="align: center"]644[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T8 Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]59[/TD]
[TD="align: center"]328[/TD]
[TD="align: center"]T8[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F86ILL[/TD]
[TD="align: center"]F96T8[/TD]
[TD="align: center"]Fluorescent, (6) 96", T-8 lamp, Instant Start Ballast, NLO (BF: .85-.95)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]59[/TD]
[TD="align: center"]328[/TD]

[TD="align: center"]636[/TD]
[TD="align: center"]645[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]60[/TD]
[TD="align: center"]369[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F86EE[/TD]
[TD="align: center"]F96T12/ES[/TD]
[TD="align: center"]Fluorescent, (6) 96", ES lamp[/TD]
[TD="align: center"]Mag-ES[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]60[/TD]
[TD="align: center"]369[/TD]

[TD="align: center"]637[/TD]
[TD="align: center"]646[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]60[/TD]
[TD="align: center"]330[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F86EL[/TD]
[TD="align: center"]F96T12/ES[/TD]
[TD="align: center"]Fluorescent, (6) 96", ES lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]60[/TD]
[TD="align: center"]330[/TD]

[TD="align: center"]639[/TD]
[TD="align: center"]648[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T8 Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]222[/TD]
[TD="align: center"]T8[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46ILL-H[/TD]
[TD="align: center"]F32T8[/TD]
[TD="align: center"]Fluorescent, (6) 48", T-8 lamp, Instant Start Ballast, HLO (BF: .96-1.2)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]222[/TD]

[TD="align: center"]640[/TD]
[TD="align: center"]649[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T8 Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]255[/TD]
[TD="align: center"]T8[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46ILL-V[/TD]
[TD="align: center"]F32T8[/TD]
[TD="align: center"]Fluorescent, (6) 48", T-8 lamp, Instant Start Ballast, VLO (BF: >1.2)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]255[/TD]

[TD="align: center"]641[/TD]
[TD="align: center"]650[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T8 Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]158[/TD]
[TD="align: center"]T8[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46SIL[/TD]
[TD="align: center"]F30T8[/TD]
[TD="align: center"]Fluorescent, (6) 48", 30W T-8 lamp, Instant Start Ballast, NLO (BF: .85-.95)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]158[/TD]

[TD="align: center"]642[/TD]
[TD="align: center"]651[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T8 Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]144[/TD]
[TD="align: center"]T8[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46SSIL[/TD]
[TD="align: center"]F28T8[/TD]
[TD="align: center"]Fluorescent, (6) 48", 28W T-8 lamp, Instant Start Ballast, NLO (BF: .85-.95)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]144[/TD]

[TD="align: center"]674[/TD]
[TD="align: center"]643[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown HO[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]95[/TD]
[TD="align: center"]721[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F86EHS[/TD]
[TD="align: center"]F96T12/HO/ES[/TD]
[TD="align: center"]Fluorescent, (6) 96", ES HO lamp[/TD]
[TD="align: center"]Mag-STD[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]95[/TD]
[TD="align: center"]721[/TD]

</tbody>
Wattage








Sheet to add the information

ABCDEFGHIJKLMNO

<tbody>
[TD="align: center"]6[/TD]
[TD="align: center"]Lighting Category[/TD]
[TD="align: center"]Lighting Subcategory[/TD]
[TD="align: center"]# of Lamps per Fixture[/TD]
[TD="align: center"]Lamp Wattage[/TD]
[TD="align: center"]Fixture Wattage[/TD]
[TD="align: center"]Lamp Type[/TD]
[TD="align: center"]FIXTURE Type[/TD]
[TD="align: center"]FIXTURE CODE[/TD]
[TD="align: center"]LAMP CODE[/TD]
[TD="align: center"]DESCRIPTION[/TD]
[TD="align: center"]BALLAST[/TD]
[TD="align: center"]LAMP / FIXT[/TD]
[TD="align: center"]WATT / LAMP[/TD]
[TD="align: center"]WATT / FIXT[/TD]
[TD="align: center"][/TD]

[TD="align: center"]7[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]

</tbody>
ADD

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Workbook Defined Names[TABLE="width: 100%"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH]Name[/TH]
[TH="align: left"]Refers To[/TH]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]Type[/TH]
[TD="align: left"]=OFFSET(CODES!$V:$V, 0, 0, COUNTA(CODES!$V:$V))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



V
Lighting Category
CFL
Circular Fluorescent
Exit Sign
LED
Incandescent
Linear Fluorescent
High Intensity Discharge
Induction Fluorescent
U_Tube Fluorescent

<tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]5[/TD]

[TD="align: center"]6[/TD]

[TD="align: center"]7[/TD]

[TD="align: center"]8[/TD]

[TD="align: center"]9[/TD]

[TD="align: center"]10[/TD]

</tbody>
CODES

[TABLE="width: 85%"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I tried making dependent drop downs the traditional way but I would need so many. For instance, for a metal halide fixture only these wattages are available.

ABCDEFGHIJKLMNO

<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]Order[/TD]
[TD="align: center"]Lighting Category[/TD]
[TD="align: center"]Lighting Subcategory[/TD]
[TD="align: center"]# of Lamps per Fixture[/TD]
[TD="align: center"]Lamp Wattage[/TD]
[TD="align: center"]Fixture Wattage[/TD]
[TD="align: center"]Lamp Type[/TD]
[TD="align: center"]FIXTURE Type[/TD]
[TD="align: center"]FIXTURE CODE[/TD]
[TD="align: center"]LAMP CODE[/TD]
[TD="align: center"]DESCRIPTION[/TD]
[TD="align: center"]BALLAST[/TD]
[TD="align: center"]LAMP / FIXT[/TD]
[TD="align: center"]WATT / LAMP[/TD]
[TD="align: center"]WATT / FIXT[/TD]

[TD="align: center"]759[/TD]
[TD="align: center"]862[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]43[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH32/1[/TD]
[TD="align: center"]MH32[/TD]
[TD="align: center"]Metal Halide, (1) 32W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]43[/TD]

[TD="align: center"]760[/TD]
[TD="align: center"]870[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]35[/TD]
[TD="align: center"]44[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH35/1[/TD]
[TD="align: center"]MH35[/TD]
[TD="align: center"]Metal Halide, (1) 35W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]35[/TD]
[TD="align: center"]44[/TD]

[TD="align: center"]761[/TD]
[TD="align: center"]871[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]72[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH50/1[/TD]
[TD="align: center"]MH50[/TD]
[TD="align: center"]Metal Halide, (1) 50W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]72[/TD]

[TD="align: center"]762[/TD]
[TD="align: center"]872[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]70[/TD]
[TD="align: center"]95[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH70/1[/TD]
[TD="align: center"]MH70[/TD]
[TD="align: center"]Metal Halide, (1) 70W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]70[/TD]
[TD="align: center"]95[/TD]

[TD="align: center"]763[/TD]
[TD="align: center"]854[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]128[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH100/1[/TD]
[TD="align: center"]MH100[/TD]
[TD="align: center"]Metal Halide, (1) 100W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]128[/TD]

[TD="align: center"]764[/TD]
[TD="align: center"]856[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]150[/TD]
[TD="align: center"]190[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH150/1[/TD]
[TD="align: center"]MH150[/TD]
[TD="align: center"]Metal Halide, (1) 150W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]150[/TD]
[TD="align: center"]190[/TD]

[TD="align: center"]765[/TD]
[TD="align: center"]858[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]175[/TD]
[TD="align: center"]215[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH175/1[/TD]
[TD="align: center"]MH175[/TD]
[TD="align: center"]Metal Halide, (1) 175W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]175[/TD]
[TD="align: center"]215[/TD]

[TD="align: center"]766[/TD]
[TD="align: center"]860[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]200[/TD]
[TD="align: center"]232[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH200/1[/TD]
[TD="align: center"]MH200[/TD]
[TD="align: center"]Metal Halide, (1) 200W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]200[/TD]
[TD="align: center"]232[/TD]

[TD="align: center"]767[/TD]
[TD="align: center"]861[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]250[/TD]
[TD="align: center"]295[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH250/1[/TD]
[TD="align: center"]MH250[/TD]
[TD="align: center"]Metal Halide, (1) 250W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]250[/TD]
[TD="align: center"]295[/TD]

[TD="align: center"]768[/TD]
[TD="align: center"]863[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]300[/TD]
[TD="align: center"]342[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH300/1[/TD]
[TD="align: center"]MH300[/TD]
[TD="align: center"]Metal Halide, (1) 300W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]300[/TD]
[TD="align: center"]342[/TD]

[TD="align: center"]769[/TD]
[TD="align: center"]864[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]320[/TD]
[TD="align: center"]365[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH320/1[/TD]
[TD="align: center"]MH320[/TD]
[TD="align: center"]Metal Halide, (1) 320W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]320[/TD]
[TD="align: center"]365[/TD]

[TD="align: center"]770[/TD]
[TD="align: center"]865[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]350[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH350/1[/TD]
[TD="align: center"]MH350[/TD]
[TD="align: center"]Metal Halide, (1) 350W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]350[/TD]
[TD="align: center"]400[/TD]

[TD="align: center"]771[/TD]
[TD="align: center"]866[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]360[/TD]
[TD="align: center"]430[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH360/1[/TD]
[TD="align: center"]MH360[/TD]
[TD="align: center"]Metal Halide, (1) 360W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]360[/TD]
[TD="align: center"]430[/TD]

[TD="align: center"]772[/TD]
[TD="align: center"]867[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]458[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH400/1[/TD]
[TD="align: center"]MH400[/TD]
[TD="align: center"]Metal Halide, (1) 400W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]458[/TD]

[TD="align: center"]773[/TD]
[TD="align: center"]869[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]450[/TD]
[TD="align: center"]508[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH450/1[/TD]
[TD="align: center"]MH450[/TD]
[TD="align: center"]Metal Halide, (1) 450W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]450[/TD]
[TD="align: center"]508[/TD]

[TD="align: center"]774[/TD]
[TD="align: center"]873[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]850[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH750/1[/TD]
[TD="align: center"]MH750[/TD]
[TD="align: center"]Metal Halide, (1) 750W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]850[/TD]

[TD="align: center"]775[/TD]
[TD="align: center"]868[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]916[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH400/2[/TD]
[TD="align: center"]MH400[/TD]
[TD="align: center"]Metal Halide, (2) 400W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]916[/TD]

[TD="align: center"]776[/TD]
[TD="align: center"]855[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]1080[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH1000/1[/TD]
[TD="align: center"]MH1000[/TD]
[TD="align: center"]Metal Halide, (1) 1000W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]1080[/TD]

[TD="align: center"]777[/TD]
[TD="align: center"]857[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1500[/TD]
[TD="align: center"]1610[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH1500/1[/TD]
[TD="align: center"]MH1500[/TD]
[TD="align: center"]Metal Halide, (1) 1500W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1500[/TD]
[TD="align: center"]1610[/TD]

[TD="align: center"]778[/TD]
[TD="align: center"]859[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1800[/TD]
[TD="align: center"]1875[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH1800/1[/TD]
[TD="align: center"]MH1800[/TD]
[TD="align: center"]Metal Halide, (1) 1800W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1800[/TD]
[TD="align: center"]1875[/TD]

</tbody>
Wattage

This is how I was doing it before I gave up:
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
Lighting Category ListCFL ListCircular Fluorescent ListDelamp ListExit Sign ListHigh Intensity Discharge ListIncandescent ListInduction Fluorescent ListLED ListLinear Fluorescent ListNone ListU-Tube Fluorescent List
CFLCFL FixtureCircular FluorescentDelampExit SignHigh Pressure SodiumHalogen IncandescentInduction FluorescentLED FixtureT5 Linear FluorescentDNDU-Tube Fluorescent
Circular FluorescentCFL Screw-InExit Sign LEDMercury VaporStandard IncandescentLED Screw-InT5HO Linear FluorescentN/A
DelampCFL Screw-In LEDMetal HalideLED Exit SignT8 Linear Fluorescent
Exit SignCold Cathode CFLPulse Start Metal HalideCFL Screw-In LEDT8HO Linear Fluorescent
High Intensity DischargeT10 Linear Fluorescent
IncandescentT12 Linear Fluorescent
Induction FluorescentUnknown
LEDUnknown HO
Linear Fluorescent
U_Tube Fluorescent
None

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: center"]Lamps per Fixture List[/TD]
[TD="align: right"][/TD]
[TD="align: center"]_0[/TD]
[TD="align: center"][/TD]
[TD="align: center"]_1[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: center"]_0[/TD]
[TD="align: right"][/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[TD="align: center"]_0.5[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_1[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_1.5[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_2[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_2[/TD]

[TD="align: center"]5[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_3[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_3[/TD]

[TD="align: center"]6[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_4[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_4[/TD]

[TD="align: center"]7[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_5[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_5[/TD]

[TD="align: center"]8[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_6[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_6[/TD]

[TD="align: center"]9[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_8[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_7[/TD]

[TD="align: center"]10[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_9[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_7.5[/TD]

[TD="align: center"]11[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_10[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_8[/TD]

[TD="align: center"]12[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_12[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_9[/TD]

[TD="align: center"]13[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_10[/TD]

[TD="align: center"]14[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_10.5[/TD]

[TD="align: center"]15[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_11[/TD]

[TD="align: center"]16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_12[/TD]

</tbody>
Wattage Table Codes

Is there an easier solution? Thank you in advance. I apologize if I did not post the pictures correctly.
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Forum statistics

Threads
1,223,886
Messages
6,175,191
Members
452,616
Latest member
intern444

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top