I have a spreadsheet (attached) where I need to be able to select either Type or Category and if so it will show the appropriate Question or Questions associated with the partial or full selection. The selection should be a drop down box that only shows the selections that are relivant once the first selection is made.
So if you select Type, it will display (to the right) all the questions in that "type". If you then select Category, it only shows the questions (a subset) that match up to both criteria. You must be able to look up the other way as well (i.e. select Category, than Type).