If>Data Validation

[MGumbrell]

Is it possible without VBA to:-
Based on the value of range A1 to allow corresponding drop down list in B2
ie
If range A1 = "yes" then the drop down list (Data Validation) in range B1 will display 1, 2, 3, 4, 5

If range A1 = no then the drop down list (Data Validation) in range B1 will display A, B, C, D, E

If range A1 = other then the drop down list (Data Validation) in range B1 will display Mon, Tue, Wed, Thur, Fri

Can the above be produced through the If formula based on the Data Validation value being a name.

=If(A1=yes,DATAVALIDATION(B1)=Number,"") then nested IF's for the rest
hope you get the idea.

Many Thanks, Matt

 

[Ginny2222]

Yes you can.
Add your Nested If Formula to the source field in the Data Validation dialog box.

=IF(A1="one",List1,IF(A1="two",List2,List3))

where "one", "two" and "three" are the value in cell A1 and List1, List2 and List3 are named lists set up in separate columns. Works for me. (You can nest up to 7 lists, although there are ways of extending this also).

rgs
Ginny

 

[MGumbrell]

Brilliant

Thank you.
Matt