Searching keyword

Closed
Dumbfounded in Canada - May 11, 2012 at 12:59 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- May 11, 2012 at 06:05 PM
Hello,

I hope I'm clear enough....

I was tasked to create a database of questions and responses in excel. What I'm trying to do is for the user to "type" in a keyword in cell A1 for a question they need to answer. (for exemple: what is an apple?, they could type "apple" in cell A1).

These questions and answers are to be hidden into another sheet.

I would like all questions that has "apple" in its text to show up in cell B1, C1, D1, etc. From there I will do a vlookup in cell B2, C2, D2 to get the answer.

I'm not certain if I am missing information in my question... please let me know!

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
May 11, 2012 at 06:05 PM
could you post a sample work book with some sample data and sample answer at some file sharing site and post back link to the file back here. it might be easier for you to explain and other to understand
0