Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-13-2012, 03:26 PM
omtinole omtinole is offline Data table search function Windows XP Data table search function Office 2003
Novice
Data table search function
 
Join Date: Mar 2011
Posts: 1
omtinole is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 07-13-2012, 10:03 PM
macropod's Avatar
macropod macropod is offline Data table search function Windows 7 64bit Data table search function Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Is there a reason you can't achieve this via filtering?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data table search function MS word starter does have search function?? adasodava Word 1 01-16-2012 08:28 PM
Data table search function Data validation using indirect function BullMouse Excel 2 11-30-2011 05:25 PM
Data table search function 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft