Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post

    Formula in data validation List

    Loungers,

    I'm tring to get data validation list to change values depending on a value in another cell.

    ie - if cell AG12 = 1, in the data validation list, put 0 or 3, if the value in AG12 is empty, in the data validation put 0,1,2,3

    Any thoughts/ suggestions woudl be very welcome

    Thanks
    Last edited by verada; 2012-07-16 at 03:41.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    If you use ranges for the source, you can use a formula like:
    =IF($AG$12=1,range1,range2)
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post
    Thanks Rory. will try that/

    Regards

Posting Permissions

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