how to include more formulas in Data validation

nalaka

New member
Joined
Jun 14, 2014
Messages
2
Reaction score
0
Points
0
i have written a formula for "k"(car type) column in data validation to change the displaying drop-down data list based on value of the "J"(No. of seats) column. i used "if" in data validation to do this. but i cannot write more repetition of "if" inside of the data validation. data validation dialog box do not allow to do this. so i cannot increase "No. of seats" data.=IF(J9="a",$G$3:$G$5,IF(J9="b",$G$7:$G$9,IF(J9="c",$E$13:$E$16,0)))
please help me to do in anther way. even by using macros


Capture.JPGCapture2.JPGCapture3.JPG
 

Attachments

  • Capture.PNG
    Capture.PNG
    13.1 KB · Views: 15

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
Give the range G3:G5 a defined name of a, G7:G9 a defined name of b, etc, and then use a data validation formula of = INDIRECT(J5)
 

nalaka

New member
Joined
Jun 14, 2014
Messages
2
Reaction score
0
Points
0
Capture4.JPG
thank you very much for helping :)

did you say giving define name as above?
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
I don't know what that picture is meant to show.
 
Top