Trying to make multiple drop down lists that excludes cell in a ra

J

Joe

Here is my scenario. I'm have a list of products that are in varying sizes.
Now all of the sizes fall into a certain range, but not all of the products
come in the same sizes.
Example: Product X is available in sizes 1, 2, 4, and 5, but product Y only
has 2, 3, and 5.
Is there a way to create a drop down list (or similar, wanting to keep it in
one cell if possilbe) that uses a range containing 1 - 5, but exclude
certain values.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top