Hi Caroline

You can only do it if you have another "tier" in your system.
Column A Great Britain
Column B England
Column C London

That being the case, then for France, you would need to Select France in
Column A, and the Only option for France in Column B would be France, which
would have to be selected again, before you could select Paris in Column C.
Does that make sense.

--
Regards
Roger Govier

"Caroline" wrote in message
...
Thanks Roger. So do you mean that there is no way to split the continuous
list? I just have to have two drop downs listing all the cities in Great
Britain and am not able to have one for England one for Scotland etc?

"Roger Govier" wrote:

Hi Caroline

In that case, your list for Great Britain would have to be a continuous
list
of all the Cities - London, Manchester, Edinburgh, Glasgow, Cardiff,
Swansea
etc.
Then in column B your DV would be INDIRECT($A2) and in Column C it would
be
INDIRECT($A2)

--
Regards
Roger Govier

"Caroline" wrote in message
...
Thank you for your suggestion, but I don't think that website explains
exactly what I am looking for.

It's not that I need three drop-downs, A B & C, where the selection in
A
determines B and the selection in B determines C.

Instead, I need the selection in A to determine B & C.

For instance, if the first validation list has France and Great
Britain,
and
I choose France, there is just one dependent drop down, listing Paris,
Lille,
Avignon, etc. But if I choose Great Britain, there should be two drop
downs,
one listing cities in England (London, Manchester etc) and one listing
cities
in Scotland (Edinborough, etc). The user would need to choose cities
in
both
England and Scotland, but those choices would not affect each other.
Does
that make sense?

"Eduardo" wrote:

Hi Caroline,
Take a look to Debra Web she has the solution you are looking for

http://www.contextures.com/xlDataVal02.html

If this was helpful please click yes, thanks