+ Reply to Thread
Results 1 to 1 of 1

Select multiple criteria based on check box selection and return all unique values.

  1. #1
    Registered User
    Join Date
    London, England
    MS-Off Ver
    Excel 2010

    Select multiple criteria based on check box selection and return all unique values.

    Hi, I am trying to create a searchable database so that the user can select a series of check boxes and when they click search it looks at another sheet and returns the corresponding locations. Note: The search criteria has 2 categories, and multiple criteria can be selected.

    I have messed around with a User Form (using dynamic named ranges) so a user selects the check boxes, then a destination range is populated with the checkbox selections, and then another area uses Index Match formulas to perform a lookup of the criteria selected
    (in the destination range). ( [CODE]{=INDEX(NamedRange, MATCH(1, COUNTIFS(CriteriaRange1, Criteria1,CriteriaRange2, CriteriaRange2), 0))}[/CODE )

    The problems that I face are:
    1) More than one unique value might meet the criteria selected, and all have to be shown in the results. (perhaps some loop function could solve this?)
    2) Numerous criteria might be selected, depending on the users requirements.

    So, I had another idea which is attached. But I don't know where to start or if it's even plausible?? I think this is quite a unique request but if there is any information out there or anyone wishes to take up the challenge I would love some help! Thanks!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread


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