Excel: Dependent Drop Down Lists with OFFSET, CHOOSE, INDEX and INDIRECT

Excel: Dependent Drop Down Lists with OFFSET, CHOOSE, INDEX and INDIRECT

 

 

Learn how to create conditional drop-down Excel Validation lists using the INDEX function, OFFSET, CHOOSE and INDIRECT Functions. One aim, many ways to get there. Which one do you like? 

Related Topics:

• Get ALL External Links with This SIMPLE Excel TRICK (as NEVER seen before!)
• VBA to BROWSE and COPY Data from SELECTED File in Excel 
• Excel List Box to Display and Print Multiple Sheets as ONE Print Job with VBA
• Free Excel Tool: Unhide Worksheet Utility (select sheets to unhide)