Dependent Drop-Downs

I think the only way to achieve this is using a macro (VBA).
HAve you tried it?
BTW, San José, where? i Costa Rica or California? As Rústico I would say C.R. but ...?
It's bed-time here (Holland) so I'll read your answer tomorrow (or somebody else picks it up).

You would do this by creating named range for each level, and using INDIRECT( to access the level you need. Attached is a sample File I created that does this, and explains how to do it. Give it a shot and let me know how you make out?

Hello Rustico18,

Here's a solution using a helper cell.

Look at the data validation and the use of the offset function. It's not dynamic, but if you want to go with this setup it can easily be applied.

Happy to help