Drop Down, Single Answer, Auto Populate

Excel Drop Down.jpgExcel Drop Down 1.png
Hi,

I created a dependant drop down list. I would like any selections with only one value to choose from to fill in automatically, and the cells with multiple selections available to show blank (Dropdown arrow), until the dropdown is picked.

Example:

I set up a table which I then made into a pivot table. Based on the pivot table I changed the names of the "Category" to match the "Name" associated with it in the name box. I then made a dependent dropdown (Column F) =INDIRECT(E2) to get my answers.

However, only two names of the 5 have more than one answer to choose from. Is there a way to have the dropdowns with only one value to autopopulate to that value?


Such as if the Name Derek was picked, I would want Green to be selected, so that I would not have to push the dropdown and pick myself. I am working with a huge amount of data so I want to be able to make this quicker, or less complicated.

My list will be continuously growing, so I will need this fix to carry down the whole column.

The real purpose of this is to cateforize a large list of companies, and arrange them based off an initial list to the category that they are currently working on. Sometimes a company will work on only one category, and other companies might work 3-6 different categories. How can I configure this so that I only need to choose the category for the companies that are working in multiple categories?

I hope I explained my issue enough. If anything isn't clear, let me know.

Thanks for your help!

Thank you for the advice, I am new to this and wasn't even sure how to attach a workbook at first!

Attached you will find the workbook. The dropdown is in Column F. As you can see for "Becca" there are two choices so I pushed the dropdown and picked one. However, for "Chelsey", there is only one selection to pick. Whenever there is only one selection, can the answer autopopulate the cell?

So when I enter "Chelsey" in Column E, how do I get Yellow to appear in Column F?
Micro Comm Question.xlsx

Thanks in advance!

Hi! I know this post is pretty dated, but did you ever figure out the answer to your problem? I have a similar issue right now and I am stuck at this point. Thanks!