lists in excel

I am trying to create a database using excel for storing machine information on 3 different production lines.
I want to have 2 drop down lists. one for the user to select the production line and the other for the user to select the machine to filter out the required machine information on the required line. Now the case is that some machine names are different on the different production lines. is there a way in excel to display the contents of the second drop down list with relation to the production line selected on the 1st list in other words suppose if line A was selected than the contents(machine names) of the 2nd list would change automatically to match line A and if Line B is selected then the entries in the 2nd list match Line B.

much needed help,
thanx