Validation with two lists

  • Thread starter Thread starter tclohesy
  • Start date Start date
T

tclohesy

Hi,

Can anyone tell me how to have a conditional cell validation for a
list. Say I have A1 with a choice of two inputs, and then a list to
choose from in A2 which changes, so use list 1 for input 1 in A1, and
list 2 for input 2 in A1.

Thanks
 
"tclohesy",

I can't access Debra's site at the moment, but it goes something like this -

In A1, your data validation (source) list is List1,List2.

You have 2 named ranges in B1:B3 and C1:C3 (List1 and List2 respectively).

The validation (source) list for A2 is =INDIRECT($A$1)

Then you can use the A1 dropdown to toggle A2 options between B1:B3 values
and C1:C3 values.

HTH,
Andy
 
Back
Top