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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
Data Validation List from a Dynamic Named Range on Another Workshe 5
Data Validation List Names 2
Data Validation and Dependent Lists Q 4
Create two Data validation lists that are linked(Both change toget 2
Selecting a cell entry based on cell validation selection 2
Data validation & indirect 1
custom data validation on cells with data validation values 2

Back
Top