+ Reply to Thread
Results 1 to 2 of 2

Looking to narrow down a list based on which boxes a user checks

  1. #1
    Registered User
    Join Date
    11-14-2013
    Location
    San Francisco
    MS-Off Ver
    Excel 2010
    Posts
    1

    Looking to narrow down a list based on which boxes a user checks

    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?

  2. #2
    Registered User
    Join Date
    10-13-2013
    Location
    China
    MS-Off Ver
    Excel 2011
    Posts
    15

    Re: Looking to narrow down a list based on which boxes a user checks

    I gave it a try and it seems like you could use a formula like this:

    =IF($B$2=$B$1,"Subtopic 1","")
    =IF($B$2=$B$1,"Subtopic 2","")
    =IF($B$2=$B$1,"Subtopic 3","")

    I've attached a screenshot I've how it looks on mine.

    Screen Shot 2013-11-15 at 10.43.13 AM.png

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro that checks a list, and gives user prompt for action
    By jayherring86 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-30-2013, 09:12 AM
  2. Replies: 3
    Last Post: 03-18-2012, 01:54 PM
  3. Replies: 6
    Last Post: 12-15-2011, 05:08 PM
  4. Checking a check box that checks other boxes on other sheets
    By caliskier in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-25-2008, 10:55 AM
  5. [SOLVED] List Boxes New User
    By LostNFound in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-18-2006, 09:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1