Data Validation in Excel - Is This Possible?

[BRISTOL86]

I want to restrict the list of choices for input in a cell based on the selection that is made in a prior cell.

For example Column A is 'Category' and Column B is 'Subcategory'. Ideally, depending on which category is selected (I've got as far as defining a list of acceptable answers) in Column A, this will then determine what choices are allowed in Column B.

I presume that's possible somehow by way of a lookup to a list of which subcategories belong to each category?

Thanks

[BRISTOL86]

Great, thanks!