Forum Discussion
JackLou
Nov 28, 2023Copper Contributor
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 video using 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!