Search : in
By :

Text resulting in drop down list

Last answer on Oct 14, 2009 1:28:25 am BST Celle, on Oct 13, 2009 8:53:32 pm BST 
 Report this message to moderators

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.

Configuration: Windows XP Internet Explorer 6.0

Best answers for « Text resulting in drop down list » in :
Delete an MSN Messenger account ShowDelete an MSN Messenger account You want to sort or remove nicks appear in the drop-down list to start MSN Messenger? There are several ways to proceed: Deleting an account with MSN version 7 Start Msn7 In the "Tools" menu...
[MS-Dos]List the contents of a directory in a file Show[MS-Dos]List the contents of a directory in a file Intro Explanation Intro It may be convenient to make the listing of one or more directories in a file, to make a catalog of files. Under MS-DOS (or Windows by opening a...
How can I save web pages on my computer? ShowHow can I save web pages on my computer? IE Google Chrome Firefox IE For Internet Explorer, click on the File menu. Click on "Save As" In the "Save as type" field, drop down the list and choose "Web Archive (Single...
HTML forms ShowForms Interactive forms let web page authors give their pages interactive elements, such as for receiving messages from their readers, much like the reply cards found in some magazines. The reader enters information by filling in fields or clicking...
CSS - Style sheets ShowFont properties Property Value Description font-family Specific font (Arial, Times, Verdana) Familly (serif, sans-serif, fantasy, monospace, cursive) Defines one or more font names or font families. If multiple fonts are defined,...

1

 venkat1926, on Oct 14, 2009 1:28:25 am BST

Study this webpage

http://www.contextures.com/xlDataVal02.html

Excel Data Validation -- Create Dependent Lists

Reply to venkat1926