Unsure how to set up Data validation, dependent on value from list
Results 1 to 5 of 5

Thread: Unsure how to set up Data validation, dependent on value from list
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Feb 2010
    Location
    London, UK
    Posts
    9,277
    Post Thanks / Like
    Mentioned
    24 Post(s)
    Tagged
    3 Thread(s)

    Default Unsure how to set up Data validation, dependent on value from list

    Hi,

    I have a cell named File_Filter that contains data validation of a list with 5 values a user can select.

    I have a second cell named Quanto, which should always read "No", unless a specific value from File_Filter is selected, in which case, value of Quanto should be "Yes"

    Effectively, my ask is:
    Code:
    If File_Filter = "tango" Then
      Quanto = "Yes"
    Else
      Quanto = "No"
    End if
    However, I want to avoid any VBA code based solutions. Can this be done just using Excel and data validation or other Excel built in feature?

    Searching online, I can only find articles relating to drop-down lists dependent on values in other cells but it doesn't seem applicable in my case or I need help to implement.

    Thanks in advance,
    Jack


  2. #2
    Board Regular
    Join Date
    Feb 2010
    Location
    London, UK
    Posts
    9,277
    Post Thanks / Like
    Mentioned
    24 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Unsure how to set up Data validation, dependent on value from list

    Forgot to mention, I wish to avoid using a formula in cell Quanto as well.


  3. #3

    Join Date
    Sep 2015
    Posts
    130
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Unsure how to set up Data validation, dependent on value from list

    dunno i cant understand your problem; can you formulate it on a sheet with the expected behavior and paste here using Mr.Excel HTML maker?

    what i understood looks quiet simple and straight forward to do:

    Excel 2010
    BCDEFGH
    2File_nameQuantoz
    31alphaalphano
    42bravo
    53gamma
    64monkey
    75echo
    8
    9
    10

    Sheet1



    Worksheet Formulas
    CellFormula
    F3=IF(E3=C6,"yes","no")


  4. #4

    Join Date
    Sep 2015
    Posts
    130
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Unsure how to set up Data validation, dependent on value from list

    data validation is set on E3

  5. #5
    Board Regular
    Join Date
    Feb 2010
    Location
    London, UK
    Posts
    9,277
    Post Thanks / Like
    Mentioned
    24 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Unsure how to set up Data validation, dependent on value from list

    I wanted to avoid using a formula in the Quanto cell (thread #2), but have since reverted to together with cell protection and locked worksheet.

    Problem resolved and thread closed.
    Last edited by JackDanIce; Nov 19th, 2015 at 08:01 AM.


Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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