Drop Down Lists

[MA]

I want to create a drop down list where the variables change depending on
what has been selected in a previous cell. I can create lists, but am not
sure how to make the second list change based on the previous entry

 

[Luke M]

See Debra's article on dynamic validation:

http://www.contextures.com/xldataval02.html