Cell value to trigger list of selections

[charliew]

Afternoon,

I am very sorry, this is a from scratch question as i'm not even sure if it's doable!

i am doing a spreadsheet based on UN transport numbers, the best example to get across what i am trying to do is 1950

[TABLE="width: 414"]
<tbody>[TR]
[TD]1950[/TD]
[TD]WASTE AEROSOLS, asphyxiant[/TD]
[TD]2.2[/TD]
[/TR]
[TR]
[TD]1950[/TD]
[TD]WASTE AEROSOLS, corrosive[/TD]
[TD]2.2, 8[/TD]
[/TR]
[TR]
[TD]1950[/TD]
[TD]WASTE AEROSOLS, corrosive, oxidizing[/TD]
[TD]2.2, 5.1, 8[/TD]
[/TR]
</tbody>[/TABLE]

this data is in sheet2

sheet 1 i have a table where i enter 1950, there is currently a formula in place that will autofill the rest of the information BUT because there is more than 1 selection it will just select the first one which is sometimes incorrect.

SO...what i want to do is if someone enters 1950 a selection box comes up where they can click asphyxiant/corrosive/corrosive,oxidising etc and then the rest of the cells are autofilled depending on the selection.

Apologies if this question has already been asked...i tried searching but to be honest im not even sure what im supposed to be searching for!

Many thanks in advance!

Charlie