pull down menus.

Hi folks

First post on this board so please bear with me.

I am trying to create a spreadsheet for my work which enables customers to configure their equipment how they want it delivered at the time of ordering.

I have created a number of pull down menus using the data validation option.

What I now want to be able to do is when one of the pull down menu options is selected is to show the associated data for that option.

For example:

Frequency band: pull down menu

Frequency range: should show
range of option selected from pull down menu above.

Can anybody let me know how I can go about doing this?

Thanks