How to Base one drop down list on another in Microsoft Excel

Mar 12, 2010 10:51 PM
Article cover image

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 updated Apple Intelligence capabilities, new wallpapers, and enhancements to Calculator, PDF cropping, and Live Voicemail, among other useful features. Find out what's new and changed on your iPhone with the iOS 18.3 update.

Related Articles

Comments

No Comments Exist

Be the first, drop a comment!