Previous Topic Next Topic

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

Answer 1 / 1
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

Similar discussions

Snapchat block list
Jasonve -
dwebb -

1 response
Facebook Messenger - Suggested Friends
jadess_0462 -
Akajackal -

2 responses
Blocked account list shuffled without me unblocking or blocking
Besmir85 -
Ec92 -

6 responses
WOW equipment return
aakash12345_0667 -
HelpiOS -

1 response
lava hard reset & factory reset
AVAY -
Har -

3 responses