drop down list based on other drop down list pick
 

I have a drop down list in Excel which contains 4 possible entries. I want
to enter another drop down list based on the entry picked from the first drop
down list. I have done some research and have come up with vlookup or if
statements, but still can't figure it out. vloopup seems to be an auto-fill
based on the answer when in my case it will be several possible answers that
I want to display. Thank you

drop down list based on other drop down list pick
 

Check out the below link on how to create Dependent Lists

http://www.contextures.com/xlDataVal02.html

If this post helps click Yes
---------------
Jacob Skaria


"Ruth" wrote:

I have a drop down list in Excel which contains 4 possible entries. I want
to enter another drop down list based on the entry picked from the first drop
down list. I have done some research and have come up with vlookup or if
statements, but still can't figure it out. vloopup seems to be an auto-fill
based on the answer when in my case it will be several possible answers that
I want to display. Thank you