The file named Candybardata.xlsx contains a list of stores where you sell candy bars. The worksheet also contains the types of candy bars you sell at each store and the price charged for each candy bar. Set up the worksheet so that users can enter or select both the store and a candy bar from a drop-down menu and have the price show up in D19. This involves the following steps:

Enable users to select a store from the drop-down menu in B19. 

Set up a drop-down menu in C13 to let users choose a type of candy bar from a list containing only those candy bars sold at a selected store.

Also, if you change the store in B19, then C19 might temporarily not list a candy bar sold at the newly selected store. If this is the case, cell C19 should contain the value Make selection above. For example, if B19 contains CVS and C13 contains gumballs, then C19 should display Make selection above.