how to include more formulas in Data validation

nalaka · Jun 14, 2014

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

Bob Phillips · Jun 14, 2014

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 · Jun 14, 2014

thank you very much for helping

did you say giving define name as above?

Bob Phillips · Jun 19, 2014

I don't know what that picture is meant to show.

how to include more formulas in Data validation

nalaka

New member

Attachments

Bob Phillips

Super Moderator

nalaka

New member

Bob Phillips

Super Moderator