yogi_Create A DropDown List Of Associated Cities In Cells B2 to B When Name Of a State Is Entered In cell A2

                                          Google Spreadsheet   Post  #1479
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-08-2014

question by cherry rozelle (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/SrZdtefokCs)

Data validation or IF statement that populates a dropdown list in a cell, based on the value in another cell

I have a spreadsheet with two columns:

Col A = State

Col B = City

I want a data validation or IF statement so that Col B has a drop-down list that is based on the value in Col A.

For example...

If A2=California, then B2 should return a dropdown list with all the cities in California (i.e. Los Angeles, Beverly Hills, etc.)

If A3=New York, then B3 should return a dropdown list with all the cities in New York (i.e. Manhattan, Syracuse, etc.)

Help please!

-------------------------------------------------------------------------------------------------

as of Jan-08-2014 I have noticed there is a problem displaying Google New Sheets in my blog posts

so in case my spreadsheet is not being displayed in the blog post, I am posting an image of the spreadsheet  as well