User Profile
JackLou
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Dropdown lists: Concatenate values to identify range?
Hey everyone, I'd like to create a dropdown list that depends on 2 previous entries dropdown lists. I'll use an example of menu options to illustrate my problem! The first dropdown is binary: either "meat" or "vegetarian". The second dropdown has multiple entries: "salad", "soup", "pasta", "baguette" etc etc. Combining entries from these 2 dropdowns would then define the possible entries for the third, which lists the various dishes available. For example, if I selected "meat" and then "pasta", the third dropdown would list the meat pasta dishes available. I'd like this to be a table, so: This videousing the OFFSET formula doesn't quite work as the second dropdown only depends on a single value from the first. I saw one Youtube video which shows the use of INDIRECT and concatenation which could perhaps solve it - the data validation from the third cell could combine the values of the first 2 cells to point to a specific range? Any help would be much appreciated!
