Forum Discussion
Dynamic drop-down list
Dear All, I have an Excel file with 2 sheets: one for employees, and another one for trainings: In Employee sheet I have 2 columns to choose from trainings listed in the ...
Attached is one way to do it. This takes advantage of the FILTER function, and that requires either a fairly new Excel or a subscription to Microsoft 365
Here's a YouTube video that explains this use of the FILTER function more fully.