-
EXCEL 2013 DEPENDENT CELLS
I am using Excel 2013 and I want to have a list of items in one cell and depending on which item is selected, I want to have a second list of items shown that are dependent upon the first selection.
For example, in column A I have a data validation look up to a list of items. In column B, I want to show related items dependent upon what is selected in column A. If a user selects food, I want to have column B only show food items. However, if the user selects cars from column A, I want column B to only show car options.
I have a total of 99 various items in column A that could be selected.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules