Forum Discussion

julijazas's avatar
julijazas
Copper Contributor
Apr 20, 2022
Solved

Return multiple values into data validation list drop down

Hi I have a Sheet called "Packing list". There i have 2 data validations. First validation called Customer returns all customers in drop down list from Sheet "Customers" In second i want to retur...
excel
Formulas and Functions
  • mathetes's avatar
    mathetes
    Apr 20, 2022

    julijazas 

     

    It's a little difficult to discern exactly what you're seeking, but this may meet the need. It's what I call a "cascading data validation" model.....where the second set of data varies depending on what was selected first. See if it helps you as a possible solution.

     

     

mathetes's avatar
mathetes
Gold Contributor
Apr 20, 2022

julijazas 

 

It's a little difficult to discern exactly what you're seeking, but this may meet the need. It's what I call a "cascading data validation" model.....where the second set of data varies depending on what was selected first. See if it helps you as a possible solution.