Still don't understand. 6 columns,
category
question
response
source
use by
contact

so where do you want your dropdown? in a seperate sheet?
If you just want to shows all Q&A's for one category I am sure you would
know to apply the autofilter...


"Georgiana" wrote:

Hi rdwj, thank you for taking the time to respond. You are right except in
your assumptions below. I actually have 6 columns including a category
column, a question column, response and source column, use by and contact
columns and I want to be able to use a drop down bar on each category (25 of
them) to expand the category's many questions and answers, and populate
across the spreadsheet like I'd do a regular filter. So If I hit the category
column, it will show all the questions related to that category and all the
questions and answers relating to that category. The questions and responses
are more than one. I would attached the spreadsheet but this source doesn't
show how I can attach a document. Thank you.

"rdwj" wrote:

not sure I fully understand the problem; you have a list of questions, one of
which can be selected through a drop down list - after which you want the
answer displayed in a second cell?
If so, a assume you have a table with the questions in col a and the answers
in col b. Suggest that you use a lookup (ensure that the list is alphabetic
on the questions) to lookup the answer.

"Georgiana" wrote:

I have a spreadsheet with questions and answers. I would like to have each
category (or question) listed once using a drop down arrow, then expanding
for the answers. Thank you.