|
|
#1
07-13-2012, 03:26 PM
|
|||
|
|||
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? 
|
|
|
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 |
Windows XP 
Office 2003
Threaded Mode