Hello All,

I looking to create a spreadsheet that has a main drop-down list to select from and then for each possible selection have different instructions appear below.

For example ~

Lets say the options of the drop-down are apple, bread, & milk

I want to be able to select apple then below in the next cells have directions for how to navigate your way through a store to find the apple.

However, if I would then go and select bread then I would want the different directions displayed below in the same area as the apple directions on how to get to the bread.

The drop-down list is not the problem. I understand how to accomplish that. The different directions appear are what I am having difficulty with

Do I need to use an "IF" statement or how should I approach this?

Thanks