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.
1 Answers
0
votes
For your table, you can use IF/Then statements that point to that drop down cell. If your drop down, for example, is in A1, you can do this where you want your data to show: =If($A$1="Apples",[whatever you need to show Apples' info],If($A$1="Oranges",[whatever for Oranges],If($A$1="Pears",[pear stuff],if($A$1="Grapes",[grape info],)))))
Note: You can do just about any formula, so you could do a vlookup or index/match, just pointing the formulas to your drop down cell.
Edit: I don't know what your info looks like, but for example, you can use index/match to return different types of Apples:
So, if you change "Apple", in B2, to "Oranges" then the three types will automatically change to "Regular","Xtra-Orange","Clementine". Is that the sort of thing you're looking to do?
