Hi there,

I've been searching all over the place for an answer to this one, but finding nothing.

I'm looking to create a prototype search facility. As it stands, i've got a spreadsheet with 2 sheets.

Sheet 2 holds a database of titles in column 1 and tags in a number of other columns referring to the title in priority order (e.g. column b-c is priority 1, d-e is priority 2 and f onwards priority 3)

Sheet 1 holds a number of checkboxes that relate to the tags.

What I want to do is allow the user to select various checkboxes and hit submit. This would then bring up a list of titles that are a closest match to the categories they have selected in the checkboxes. Also, a secondary and tertiary list which would go by the lower priority tags. (but I only want to show the titles, not all the categories in the same row)

So, in my most basic terms;

user clicks a selection of categories, and hits submit.
list comes up below the form of the primary, secondary and tertiary matches according to the combination of categories selected (this list appearing on sheet 1)

If anyone has any ideas, I'd be really grateful, I've tried everything I can think of.