This post has been de-listed
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
I am attempting to make a more user-friendly order sheet. We have all of the our options in a list, we'll use teddy bears for example. So the list includes teddybear-1, teddybear-2, teddybear-3. Each of these teddy bears has a list of standard options/features associated with them in a separate list. When I select a teddy bear option in cell A1, I would like cells B1 - whatever auto-populate the list of standard options based on the teddy bear I selected. I know how to make a list and I know how to use data validation to lock cells to a list only. VLookup isn't an option because it's not a 1-1. I am looking for a solution that will populate the data as described above.
Subreddit
Post Details
- Posted
- 1 year ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/excel/comme...