Excel Simple Dependent Drop down List based on numbers (Index without match)

Excel Simple Dependent Drop down List based on numbers (Index without match)

 

 

This video shows another side of the Index function. It uses INDEX to create dynamic lists based on criteria. It also uses the second argument or way of writing of the Index function which uses references as well as area numbers.  

 

The index function is then used to create dynamic drop down lists that change based on selected criteria. Name manger is used to keep the formula required for the data validation list. The given name is then directly used inside the data validation.  

Related Topics:

• Excel VBA: Check If File or Folder Exists (DIR) - Open File or Create Folder
• Link Page Header to Cell Value with Excel VBA 
• Excel ActiveX Combo Box to Select Worksheets with VBA
• Excel VBA FIND Function (and how to handle if value NOT found)