Validation in cascade...

Hi guys,

I'm trying to create a sheet where the user can make refined searches through validation.

Using Data-Validation- Allow-List, i create a drop down list within a cell.

Now this is the tricky part. Depending on the result of the cell, i'd like Excel to go to another set of fields and present me with another drop down list, and so on.

Here is an example.

I have a list of countries : US, UK, Australia,...
If i select US in this drop down list, , then a new drop down list of cities corresponding to US should be displayed in the next cell.

And so on, with streets,...

Can someone help me with that ?

Thanks a lot !

Jehan