Forum Discussion

PatrickHansen's avatar
PatrickHansen
Copper Contributor
Apr 06, 2024

Excel Data Validation

How do I make a data validation list change based on what i select from a different data validation?

  • mathetes's avatar
    mathetes
    Silver Contributor

    PatrickHansen 

     

    How do I make a data validation list change based on what i select from a different data validation?

     

    I'm attaching an example of how to do that. This does require current versions of Excel, as it makes use of some dynamic array functions. If you need more help, please come back with a more complete description of what you're trying to do.

Resources