ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Search with drop down list as answers (https://www.excelbanter.com/excel-discussion-misc-queries/114781-search-drop-down-list-answers.html)

instereo911

Search with drop down list as answers
 
Is there a way in excel to create a search engine (sort of like the "help"
function for microsoft programs) that allows a user to search a specific word
or phrase and a list of answers (or what we think an answer to their question)
would populate.

Example :

Search = "Third Party"

Answers (would be a link to get to the correct answer) =
" What am I supposed to do if a third-party rep calls?"
" What does Third Party Mean?"
" Question for Third Party"

Thank you so much.


L. Howard Kittle

Search with drop down list as answers
 
Check out dependant drop down lists here.

http://www.contextures.com/xlDataVal02.html

HTH
Regards,
Howard

"instereo911" <u27979@uwe wrote in message news:67e8ff606fdab@uwe...
Is there a way in excel to create a search engine (sort of like the "help"
function for microsoft programs) that allows a user to search a specific
word
or phrase and a list of answers (or what we think an answer to their
question)
would populate.

Example :

Search = "Third Party"

Answers (would be a link to get to the correct answer) =
" What am I supposed to do if a third-party rep calls?"
" What does Third Party Mean?"
" Question for Third Party"

Thank you so much.




instereo911

Search with drop down list as answers
 
I don't think this will work for my document. My goal is to complete a "Q and
A" for a large amount of people.

My intention is to have a document that if you type in a field box " What do
I do if someone is asking about Third Party" , another box will pop-up with
possible answers to your questions (i.e. - "Is this person a lawyer?" , "Is
this person calling on an outside line?" etc. etc.)

I am not sure (and I probably am right) that excel is not the document to do
this "Q and A" form on.

Any suggestions?

L. Howard Kittle wrote:
Check out dependant drop down lists here.

http://www.contextures.com/xlDataVal02.html

HTH
Regards,
Howard

Is there a way in excel to create a search engine (sort of like the "help"
function for microsoft programs) that allows a user to search a specific

[quoted text clipped - 13 lines]

Thank you so much.



L. Howard Kittle

Search with drop down list as answers
 
Sounds like you might be better off with a trouble shooting format in a
binder with index and such. i.e. Third Party ... page 4. On page 4 is all
the stuff on how to deal with Third Parties.

HTH
Regards,
Howard

"instereo911" <u27979@uwe wrote in message news:67e8ff606fdab@uwe...
Is there a way in excel to create a search engine (sort of like the "help"
function for microsoft programs) that allows a user to search a specific
word
or phrase and a list of answers (or what we think an answer to their
question)
would populate.

Example :

Search = "Third Party"

Answers (would be a link to get to the correct answer) =
" What am I supposed to do if a third-party rep calls?"
" What does Third Party Mean?"
" Question for Third Party"

Thank you so much.





All times are GMT +1. The time now is 05:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com