Conditional Drop Down List

Q

quindoq

I am putting together a pricing tool.

For example, in A1 - I have a drop-down list with CVR, Metro CVR and
InterCity CVR

Each name in the list is associated with a set of cities where the
service is available with specific service rates,

CVR - ATL, MIA
Metro CVR - DC, NYC, SEA
InterCity CVR - CHI, STL, NAS

So if I pick CVR in the drop down list in A1, the drop down list in B1
should only show ATL and MIA.

HELP!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to dynamically change the list in drop down list based on thevalue of another cell? 1
Pick from drop-down list gives empty or erroneous result 6
Help with creating drop down 1
Drop-down list dependant on another cell value 2
Drop Down List Showing Two Cells Info 1
Drop down list - link to another worksheet 4
Data Validation and drop-down list using IF, AND and what else? 8
drop down list in excel 1

Top