create a conditional formula

[Matt H.]

Trying to create a formula that when depending on what word is selected from
a list I created, then another list will appear in that cell

 

[Max]

One guess .. peep through Debra Dalgleish's page at:
http://www.contextures.com/xlDataVal13.html
Excel -- Data Validation --
Dependent Dropdowns from a Sorted List