You need dependent dropdowns using Data Validation.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Mon, 29 Sep 2008 08:43:00 -0700, Baffled <Baffled
@discussions.microsoft.com wrote:

I am trying to get a price list to work using excel!
I have all of the prices in one spreadsheet, but I need to process the
information a little differently.
I have several systems that when selected need to go to a secondary line
item to allow the user to select one or more options, how is this done? any
ideas
For example:
If I pick item 1 I need the spreadsheet to tell the customer that he must
then go ahead and pick up a subset of options ie board 1 or board 2 or no
board
Is there an easy way of doing this?
Thanks for any help I get