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!
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