lamp

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...

Hello, I appreciate you taking the time to look at my problem. Ineed some help in a couple of areas. I have about 6 workbooks, all with 20-70+ worksheets withinthem all correlating to different areas we work in. They are all laid out the same with column E detailingdifferent lamp types we...

<tbody> D E F G H New Lamp and/or Luminaire Initial Light Output of new End-User Equipment (lm) New Lamp Circuit Power _Watts Coef Factor Remarks 3 E1.1 A LED Lamp only_ELV 1600 2 0.49 ≤5 W=.0.49, ≤10W=0.41...

I have a sheet where I am trying to pull only the cell where the value is greater the 3 and put them in column H & I within the same sheet. I have a list in Table 1 where if "F" is > the 3 with conditional formatting on. Is there a way to pull only data from Table 1 with Qty > then 3 and match...

Hello! I have a problem, which I'm thinking about for some time already and didn't find any solution yet (and have to do it manually). I have two columns in two seperate sheets: FIRST contains shortened names of some products (for example: "Lamp") SECOND contains full names of these products...

Hello everyone, This is a very practical exercise that I am trying to do since a little while but without any success. I defined 2 informations for light bulbs : - The 1st time it is likely to burn and be replaced : For example after 2.5 years or after 0.3 year - The life time of a bulb : For...