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