PDA

View Full Version : Solved: Trigger a Validation based upon a cell value



khalid79m
02-11-2009, 07:37 AM
In A2 I have a drop down box , where some can select a product , ie car, tomato, etc.

When someone selects a car in a2 I want the next five cells to the right to validated to the named range NM_Car.

if someone selects tomato in a2 I want the next five cells to the right to be validated to the named range NM_Car


Can this be done?

Kenneth Hobs
02-11-2009, 08:48 AM
Not sure what you mean. You repeated the same thing.

If you are doing one list to subset another, add helper cell. Then, use Indirect(thehelpercell) in the data validation. If your first list has the named ranges listed, then you don't need a helper cell.

e.g.
B30 has a list of Cars1, Fruits1. In D30, I insert the proper name for the named range, =IF(B30="Fruits1","Fruits",IF(B30="Cars1","Cars",""))

The data validation List's Source in C30 is then, =Indirect(D30)

khalid79m
02-11-2009, 09:08 AM
if someone selects tomato in a2 I want the next five cells to the right to be validated to the named range NM_tOMATO

.. MY fault,

khalid79m
02-11-2009, 09:13 AM
I dont understand you response can you attach an example ?

Bob Phillips
02-11-2009, 03:44 PM
Use a DV type of List and a formula of =INDIRECT("NM_"&c1)

where C1 is the first DV.

If you get an error setting up the DV, just accept it.

khalid79m
02-19-2009, 05:32 AM
This worked a treat