use vlookup to create a dropdown list

[Dragman]

Searched and searched but could not find a similar problem.

I have a list of site operators. Each site operator runs a number of sites. I have a dropdown list to choose the site operator. I am trying to create the second dropdown list based upon the first.

List 1 = Site Operator (user chooses an operator)
List 2 = List of sites run by that operator (user chooses one of the sites operated)

I only want list 2 to show the sites operated by the operator chosen in list 1.

This has to be a vlookup solution but I am having trouble understanding the syntax for the formula?

Here is a small sample file. If I choose Jones in list 1, I only want list 2 to show "Site J1, Site J2.

Thanks to everyone for the help. Each solved problem makes me better at this!!

[prjt]

Comme ca?

This might not be how you wanted to do it, but I think this is the desired result, no?

List your operators under the "OPERATORS".
List each of their possible sites under the heading of their name (Make it identical to how you presented it under the OPERATORS heading, spelling punctuation etc).
When finished all lists highlight the operators list including header; under the Formulas tab click "Define Name"; under "Refers to:" make sure the rage is all of the operator names.
Repeat this process for each operator name making sure that the "Refers to:" references all the Site possibilities.

For Dropdown 1 use data validation to create a list; for source write =OPERATORS
For Dropdown 2 same idea; Surce: =INDIRECT(The cell where you have dropdown 1)

[Dragman]

This helped a lot!! Had some naming convention problems but worked them out.

Where would we be without the help of others. Greatly appreciated!!

Dragman