In cell B1; set data validationList and in source type..This will populate
the list with the named range mentioned in cell A1.

=INDIRECT(A1)

PS: when you apply this in cell B1 ; there will be a confirmation message if
A1 is blank. Please ignore and proceed.

"Michael Hudston" wrote:

I would like to set a validation list on a column based on the value of the
adjacent cell in the other column, but can not seem to figure out how to do
this.

I have the following named ranges.

Category Which contains :- Capacitor, Resistor, Diode, Connection and others.
Capacitor Which Contains :- Air Trimmer, Variable, Fixed, Surface Mount Etc
Resisitor Which Contains : Variable, Wire Wound Etc

I also have named ranges for Diodes, Connections and other items that appear
in the Category List.

What I am trying to achieve is

Depending on the Value I select for Column A from the Category List, then I
want the Adjacent Cell in Column B to validate against the relevant list.

Ie if in Column A i select a category of Capacitor, then the Validation in
the adjacent cell should be limited to the list in named range "Capacitor"

Where do I even start?

Help Please.