I dont know if the dependant drop downs is going to work...or i am using them in the wrong way.

Basically, to make it as simple as possible, I want the data in column X to be dependant on the data i select from a drop down list in column A

(if A is 'hot dog' then X is 'buns, franks', but if A is 'sandwhich' then X is 'bread, turkey, mayo')