title: excel drop down that populates table
body: <p>I want to create a drop down list on excel that will automatically populate a table once I click on a certain option. For example, if my drop down list has Apples, Oranges, Pears, and Grapes, and I select Apples, I want a table with data about the apple to be populated automatically. I've created the drop downs but I'm unsure how to connect a table with data back to the specific drop down option. Thanks.</p>