Hello,

Description of requirement:
I have a list of Countries of the world in column A and in Column B have a list off all States/Cities of all the countries in the world.
I want to find a formula that will show only the State/City’s for that selected Country

If country is US, in column B pull in only the state/citys in the US, and if Australia is selected then show only City’s in Australia.



Country State/City
US New York
Florida
Australia Melbourne
Canada Toronto


Thank you