Hi all,
I am creating a tool for users where they will select multiple options using drop-down lists. There are ~150 drop down lists total, and each list needs to have different options in the drop down list.
I have a master list with ~270 rows that lists each option for each drop-down menu. What I am envisioning is some version of a vlookup where it takes the category listed and then populates the drop-down list with each option associated with that category on the list.
Example 1:
Category: Conferences
Master List:
Conferences Level 1
Conferences Level 2
Conferences Level 3
[So, the drop down list next to "Conferences" would contain Level 1, Level 2, Level 3]
Example 2:
Category: Event Production
Master List:
Event Production Level 1
Event Production Level 2
[So, the drop down list next to "Event Production" would contain Level 1, Level 2]
Any help/ideas would be greatly appreciated!
Bookmarks