Using a simple questionnaire as a filter???

[lisa mcnally]

Hi,

I dont know if this is possible but i have a rather large spreadsheet that people will be using to search for different pieces of information. Is it possible to use a front worksheet that asks the user questions to filter the information down. ie. depending on how they answer the question determines the next question they get until the relevant information is shown.
eg. 1st question: Do you require red or green?
answer: red answer:green
2nd q: is the red bright or dull? 2nd q: is the green apple or leaf


This is a bit of a silly example but i hope you get the idea!!!

Thanks

Lisa