Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
murphyz
 
Posts: n/a
Default FAQ Spreadsheet with search function


I would like to create a spreadsheet called FAQs that has 2 worksheets.


A 'faq' worksheet will have a list of all of the faqs and answers to
these, possibly a third column that has 'keywords' in it.

A second worksheet will be called 'search' and should have up to three
cells where the user can type in keywords to search for.

I want these keywords to then look at the faqs and grab any relevant
rows, displaying them in the 'search' worksheet.

example.

FAQ sheet

faq 1 ~ How do you do this? ~ You do this by pointing your mouse and
clicking the button.
faq 2 ~ How do you do that? ~ You do that by clicking the button.

SEARCH sheet

If you enter the word 'mouse' into the first search cell, the sheet
will display the text for faq 1.
If you enter the word 'button' into the first search cell, the sheet
will display the text for both faqs 1 & 2.
If you enter the word 'mouse' into the first search cell, and the word
'button' into the second search cell, it will display faq 1 as a match,
and faq 2 as a partial match.

I'm not sure of the cleanest and easiest way to do this, purely using
excel and not Access. Any ideas on structure and formula/VB needed
would be greatly appreciated.

Thanks

Mxx


--
murphyz
------------------------------------------------------------------------
murphyz's Profile: http://www.excelforum.com/member.php...o&userid=20624
View this thread: http://www.excelforum.com/showthread...hreadid=355854

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conversion SVC Excel Worksheet Functions 9 February 28th 05 03:29 PM
Search function using commas Kylie Excel Worksheet Functions 1 February 2nd 05 03:46 AM
spreadsheet function Excel GuRu Excel Discussion (Misc queries) 2 January 6th 05 05:09 AM
SEARCH function #VALUE! result Mike Boerne Excel Worksheet Functions 3 January 5th 05 09:53 PM
HOW TO USE FIND OR SEARCH FUNCTION TO FILL DATA hsg Excel Worksheet Functions 2 November 18th 04 08:24 AM


All times are GMT +1. The time now is 10:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"