#1
|
|||
|
|||
Data table search function
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? |
#2
|
||||
|
||||
Is there a reason you can't achieve this via filtering?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
MS word starter does have search function?? | adasodava | Word | 1 | 01-16-2012 08:28 PM |
Data validation using indirect function | BullMouse | Excel | 2 | 11-30-2011 05:25 PM |
Search Function | Rick203 | Outlook | 1 | 08-29-2011 11:23 PM |
Search Function Problem | MageWind | Excel | 2 | 06-29-2011 09:46 AM |
Using data entered in prompt to search database table | BluRay | Word | 1 | 03-25-2011 01:47 AM |