The tutorial shows how to create an Excel drop down list depending on another cell by using new dynamic array functions.
Creating a simple dropdown list in Excel is easy. Making a cascading drop-down has always been a problem. The above linked tutorial describes four different approaches, each including a crazy number of steps, a bunch of different formulas, and a handful of limitations relating to multi-word entries, blank cells, etc.
Here is the post.