Can't create "Dependent" DropList from Non-adjacent columns

Attached file 160205 Non-adjacent Dependent lists.xlsx has a database with Client list in Col A.

Cols B and F show the names of two sites for each client. The address details for the sites site in between, in Cols C - E and Cols G - I

If I have a DropList in C6 listing both clients, is there a "formula" approach that will populate a Dependent DropList in C8 listing ONLY the site names in Cols B and F for that client? Or am I into "VBA -world"

Ochimus

Chenist.

Many thanks for the prompt response and attempt at offering something that would work.

Unfortunately having a separate dropdown for each site won't work in the "real" file. I used two "dependent" sites for the sample, but the structure has to cope with national chains that can total hundreds of different sites, Whole point is to give the End User one list that they can shuffle down and select the appropriate location,

Looks like it's VBA or nothing, unless someone else has found a tweak!

Ochimus