Advanced Dropdowns (FULL COURSE)

Microsoft Excel - Advanced Dropdowns

Understanding the use of advanced and dynamic dropdown lists using Data Validation techniques.

The topics:

  • The pros and cons of a basic dropdown
  • Creating a dynamic dropdown list
    • Establishing an Excel Formatted table as a list
    • Using the INDIRECT function
    • The benefits of a dynamic list
  • Creating a conditional dropdown list
    • Naming the tables to be used
    • The benefits of a conditional dropdown list
  • Naming convention issues affecting conditional dropdowns
    • What might present a problem?
    • Using an XLOOKUP to remedy this issue