Results 1 to 4 of 4

Thread: how to include more formulas in Data validation

  1. #1

    how to include more formulas in Data validation



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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


    Click image for larger version. 

Name:	Capture.JPG 
Views:	14 
Size:	32.0 KB 
ID:	2411Click image for larger version. 

Name:	Capture2.JPG 
Views:	55 
Size:	36.8 KB 
ID:	2412Click image for larger version. 

Name:	Capture3.JPG 
Views:	53 
Size:	67.6 KB 
ID:	2413
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Capture.PNG 
Views:	10 
Size:	13.1 KB 
ID:	2410  

  2. #2
    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)

  3. #3
    Click image for larger version. 

Name:	Capture4.JPG 
Views:	8 
Size:	18.7 KB 
ID:	2414
    thank you very much for helping

    did you say giving define name as above?

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •