Results 1 to 3 of 3

Thread: Data Validation formula?

  1. #1
    Neophyte ExcelFatigue's Avatar
    Join Date
    Jan 2022
    Posts
    1
    Articles
    0
    Excel Version
    2016

    Data Validation formula?



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

    Hi just needing some advice

    i have a dashboard but looking to make it easier to select agents from each team they have from the list

    i had inital a list of all agents from data validation however this made it harder for management to select from specific teams

    i then had a drop down of team leaders names in another cell but i want to be able to reference the agents cell to the managers cell.

    i've tried an =if statment using the name's option eg

    =IF(a1="daves team",Daves_Agents,=if(a1="shauns team",Shauns_Agents,"Change team")

    however doesn't seem to work how i would like it to work

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    2,115
    Articles
    0
    Excel Version
    365
    Best attach a workbook with all this in and an indication of the result you want.

  3. #3
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,938
    Articles
    0
    Excel Version
    O365
    Maybe this will help, How to Make Dependent Drop Down Excel 365 with Video Steps (contextures.com). Look at the Dependent Dropdown Lists video.

Posting Permissions

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