Selecting info based on a previous column

[broncos347]

I have a list of data made up of four columns, Element, Feature, Attribute, Life Expectancy, an example would be fire access & security systems(Element)>cctv system(Feature)>recorded(Attribute)>25(Life Expectancy).

Each one of the columns is related to the previous one, so if I was to select the Element of fire access & security systems I would like to only to be able to select from a defined list of Features that are available for that Element. The same should go for the relationship between the Feature and Attribute.

If I can do this then I can do a VLOOKUP for the Life Expectancy based on the Element, Feature & Attribute.

I can create a full dropdown list of all the Element, Feature & Attributes but the full list if you do it this way is over 1,200 long.

Is it possible to select from a dropdown list for the Element and then from another dropdown be able to select only those related Features and likewise for the relationship between the Feature and the Attribute.

 

[jmacleary]

Hi there. What you are after is called a dependent drop-down list. If you google "dependent dropdown excel" you will get many answers. Any of the first 10 or so will give you a tutorial on how to do it.

 

[broncos347]

Excellent, I didnt know you could do that, many thanks.