<div>
So where exactly is the drop down going? &nbsp;Is the drop down only to contain one value?
</div>


So where exactly is the drop down going?  Is the drop down only to contain one value?

<div>
The drop down goes in column E so that we can input using the information from the list. Yes... based on today's word there is only one value for each one of these
</div>


The drop down goes in column E so that we can input using the information from the list. Yes... based on today's word there is only one value for each one of these

<div>
Like NB-VC says, why a drowdown with only one value, when you can get it with a formula.<br />
But it is possible, see attached, where I have put in a formula solution in column C as well.<br />
<a href="https://filedb.experts-exchange.com/incoming/2013/11_w45/687037/DropDown-Test.xlsx" target="_blank" class="file-inline" title="Drop-down (13 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>DropDown-Test.xlsx</a>
</div>


Like NB-VC says, why a drowdown with only one value, when you can get it with a formula.
But it is possible, see attached, where I have put in a formula solution in column C as well.
DropDown-Test.xlsx [https://filedb.experts-exchange.com/incoming/2013/11_w45/687037/DropDown-Test.xlsx]

DropDown-Test.xlsx

<div>
Hi, the dropdown is to limit new records to a specific AU.. here is the actual model I created... but when I added the dropbox I get a #REF! error<br />
<a href="https://filedb.experts-exchange.com/incoming/2013/11_w45/687051/Model.xlsm" target="_blank" class="file-inline" title="Sample model (182 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Model.xlsm</a>
</div>


Hi, the dropdown is to limit new records to a specific AU.. here is the actual model I created... but when I added the dropbox I get a #REF! error
Model.xlsm [https://filedb.experts-exchange.com/incoming/2013/11_w45/687051/Model.xlsm]

Model.xlsm

<div>
<div class="content wysiwyg-content">
I have a spreadsheet where I would like to have a drop down box that allows me to select only the number that is based on the corrispondent cell in column BE. So in my first two examples if the correspondent cell in BE is FTE then the drop down box would only show 60. if the cell is cell shows Contractor in column BE then the option would be limited to the other correspondent value. Attached is the expample spreadsheet...<br />
<br />
How can I accomplish this?<br />
<a href="https://filedb.experts-exchange.com/incoming/2013/11_w45/687025/DropDown-Test.xlsx" target="_blank" class="file-inline" title="Test File (11 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>DropDown-Test.xlsx</a>
</div>
</div>


I have a spreadsheet where I would like to have a drop down box that allows me to select only the number that is based on the corrispondent cell in column BE. So in my first two examples if the correspondent cell in BE is FTE then the drop down box would only show 60. if the cell is cell shows Contractor in column BE then the option would be limited to the other correspondent value. Attached is the expample spreadsheet...

How can I accomplish this?

Drop Down option based on results from other field

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.