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

Just updated your iPhone? You'll find new features for Podcasts, News, Books, and TV, as well as important security improvements and fresh wallpapers. Find out what's new and changed on your iPhone with the iOS 17.5 update.

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest