<div>
You're looking for a conditional drop list that uses data validation. &nbsp;To make it work, you'll need to create dynamic range names that will select the dependent data.<br />
<br />
This EE question has both a link to an online article and an example solution that I provided that demonstrates it.<br />
<a href="https://www.experts-exchange.com/questions/28498440/Picking-from-a-conditional-drop-down-list.html" rel="ugc">https://www.experts-exchange.com/questions/28498440/Picking-from-a-conditional-drop-down-list.html</a><br />
<br />
-Glenn
</div>


You're looking for a conditional drop list that uses data validation.  To make it work, you'll need to create dynamic range names that will select the dependent data.

This EE question has both a link to an online article and an example solution that I provided that demonstrates it.
https://www.experts-exchange.com/questions/28498440/Picking-from-a-conditional-drop-down-list.html [https://www.experts-exchange.com/questions/28498440/Picking-from-a-conditional-drop-down-list.html]

-Glenn

EE-Pick-from-dropdown2.xlsx

<div>
Worked beautifully. Thank you.
</div>


<div>
You're welcome. &nbsp;Dynamic range names are very useful.
</div>


You're welcome.  Dynamic range names are very useful.

<div>
<div class="content wysiwyg-content">
Hi all,<br />
<br />
I've got a simple sheet here:<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/09_w38/1117092/_Fruit.jpg" target="_blank" title="screen (10 KB)"><img alt="screen" class="file-block lazyload" style="max-width: 207px;" data-src="https://filedb.experts-exchange.com/incoming/2016/09_w38/1117092/_Fruit.jpg" /></a><br />
On a different sheet, I need this to happen:<br />
<br />
In cell A1, If I choose either &quot;Apple&quot; or &quot;Orange&quot;, I need a data validation type drop-down in cell B1 that only shows the type of that fruit.<br />
<br />
So for example, if i choose &quot;Apple&quot; in cell A1, I can only choose in cell B1: &quot;Granny Smith&quot;, &quot;Red Delicious&quot;, or &quot;Fuji&quot;.<br />
<br />
Thanks in advance.
</div>
</div>


_Fruit.jpg

Hi all,

I've got a simple sheet here:



On a different sheet, I need this to happen:

In cell A1, If I choose either "Apple" or "Orange", I need a data validation type drop-down in cell B1 that only shows the type of that fruit.

So for example, if i choose "Apple" in cell A1, I can only choose in cell B1: "Granny Smith", "Red Delicious", or "Fuji".

Thanks in advance.

Excel -  Data validation from a subset?

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