Scenario:

I have a list of salable items in a product family. Beside each items are several columns identifying specific characteristics. Each item is unique, but many characteristics overlap. I want to create a search function, wherein each characteristic is listed, and the searcher can select the desired parameter from a pull-down list. Search fields may be selected or left blank, based on how specific a match the searcher requires.

Once a parameter was entered, the spreadsheet would output all matching items; subsequent parameter entries would winnow the list down. If no match was found, the spreadsheet would output “No match found”.

I can probably get there using a long series of IFs, ANDs, LOOKUPs, etc., but would prefer to use a simple matrix algorithm if possible. Anyone know if it can be done?