I'm looking for a way to use excel to narrow down a list of project suggestions for users based on the topics that they are interested in.
Basically, I'd like for someone to just check a box for each topic they are interested in, and a list of relevant suggestions would be generated for them to use on any given project.
Lets say I only have 3 Topics:
1. greenhouse gas emissions
2. waste production
3. energy use
Each of the above topics includes about 10 suggestions (30 total).
So I have one checkbox corresponding to each topic (3 check boxes total).
If someone only checks the box for greenhouse gases, I'd like only those 10 corresponding suggestions to be displayed. Same goes for if they select 2 or all 3 topics. I haven't been able to figure out how to have more than 1 suggestion listed per topic (just using an if statement).
Hopefully I've explained this clearly, can anyone point me in the right direction?
Bookmarks