Text resulting in drop down list

Closed
Celle - Oct 13, 2009 at 03:53 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 13, 2009 at 08:28 PM
Hello,

I am looking for the ability to enter specific data in a cell and have it result a specific drop down in the same cell.

For example If a person types the word "Blue" in cell A1, then a drop down list with the chooses of "baby blue", "jet blue" and "aqua blue" will appear in cell A1.

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 13, 2009 at 08:28 PM
study this webpage

https://www.contextures.com/xldataval02.html

Excel Data Validation -- Create Dependent Lists
0