Hosted on MSN2mon
Make Excel Smarter With Dynamic Dropdown Lists: Here's How They Workthe second dropdown will show employees who belong to the department selected. To create dynamic dropdown lists, you typically need to use named ranges and the INDIRECT function in Excel.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback