Go-Bruins
asked on
Excel - Data validation from a subset?
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Worked beautifully. Thank you.
You're welcome. Dynamic range names are very useful.
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
-Glenn