View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ruth Ruth is offline
external usenet poster
 
Posts: 132
Default 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