Creating a Data Validation List based on a Value in another cell

G

Guest

Hi, I wonder if anybody can help
In cell A1 there are multiple options eg London, Birmingham, Manchester, I
twould like a data validation list to appear in cell B! based on the value in
cell B1 so if it is London I have a drop down list of Waterloo, Victoria,
Kings Cross etc, but if it is Birmingham then I have a drop down list of New
Street, International Airport etc

Hope this make sense.

Thanks in advance for any help
 
G

Guest

You'll need DATA VALIDATION for one dropdown list and INDIRECT DATA
VALIDATION for the other one ( 2 dropdown lists ). If you need directions
write me back, I'm coming back in 1 hour.
 

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

Return a list based on a +/- of a cell value 14
Selecting a cell entry based on cell validation selection 2
Second cell in Data Validation 3
Data validation & indirect 1
Data Validation List from a Dynamic Named Range on Another Workshe 5
a data validation list that contains a list of named ranges - not alist from a named range 1
Data Validation lists update orginal cell with list update 3
Data Validation and Dependent Lists Q 4

Top