How To: Base one drop down list on another in Microsoft Excel

Base one drop down list on another in Microsoft Excel

Excel dilettantes and seasoned Microsoft Office professionals alike may be surprised to learn that in Excel one can make a drop down list based upon a second drop down list (or, similarly, data validation list that is based on a second validation list).

See how to create a Drop Down List that is based on another drop down list using there
features:

1)Data Validation List
2)Defined Names
3)Create Names From Selection
4)INDIRECT function
5)SUBSTITUTE function

While you're stuck at home, make the most of your time by learning a new language, skill, or even train for a remote-work job with our new premium online courses.

Check them out >

Our Best Phone Hacks

Gadget Hacks' tips — delivered daily.

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest