Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pull Down Lists
If I have built a pull down list, how do I add the ability to also add free
form content to the chosen cell? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pull Down Lists
What type of pull down list?
If it's from DataValidation disable the error alert message. Select the cell with the drop down list Goto the menu DataValidation Select the Error Alert tab Uncheck: Show error alert..... OK -- Biff Microsoft Excel MVP "Fritz" wrote in message ... If I have built a pull down list, how do I add the ability to also add free form content to the chosen cell? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pull Down Lists
Thanks very helpful...another question, if a user selects one of the items in
the pull down list there is a unique number associated with that item which I would like to have displayed in another column...how do I accomplish that? "T. Valko" wrote: What type of pull down list? If it's from DataValidation disable the error alert message. Select the cell with the drop down list Goto the menu DataValidation Select the Error Alert tab Uncheck: Show error alert..... OK -- Biff Microsoft Excel MVP "Fritz" wrote in message ... If I have built a pull down list, how do I add the ability to also add free form content to the chosen cell? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pull Down Lists
See if this helps:
http://contextures.com/xlFunctions02.html -- Biff Microsoft Excel MVP "Fritz" wrote in message ... Thanks very helpful...another question, if a user selects one of the items in the pull down list there is a unique number associated with that item which I would like to have displayed in another column...how do I accomplish that? "T. Valko" wrote: What type of pull down list? If it's from DataValidation disable the error alert message. Select the cell with the drop down list Goto the menu DataValidation Select the Error Alert tab Uncheck: Show error alert..... OK -- Biff Microsoft Excel MVP "Fritz" wrote in message ... If I have built a pull down list, how do I add the ability to also add free form content to the chosen cell? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pull Down Lists
Sorry, I'm a bit of a neophyte at this...having trouble understanding
this...can you help me? "T. Valko" wrote: See if this helps: http://contextures.com/xlFunctions02.html -- Biff Microsoft Excel MVP "Fritz" wrote in message ... Thanks very helpful...another question, if a user selects one of the items in the pull down list there is a unique number associated with that item which I would like to have displayed in another column...how do I accomplish that? "T. Valko" wrote: What type of pull down list? If it's from DataValidation disable the error alert message. Select the cell with the drop down list Goto the menu DataValidation Select the Error Alert tab Uncheck: Show error alert..... OK -- Biff Microsoft Excel MVP "Fritz" wrote in message ... If I have built a pull down list, how do I add the ability to also add free form content to the chosen cell? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pull Down Lists
Well, it depends on how you intend to use the drop down list.
If you only have a "few" (less than 5 or 6) items in your list you can use a formula like this: Assume cell A1 contains the list. =IF(A1="item1",value1,IF(A1="item2",value2,IF(A1=" item3",value3,""))) If your list contains "many" items then you need to create a 2 column table like this: ........X...........Y 1..item1.....value1 2..item2.....value2 3..item3.....value3 etc etc Then you would use a formula like this: =VLOOKUP(A1,X1:Y3,2,0) However, since you allow users to manually enter items *not on the list* you would need to account for that in whatever formula you decide to use. -- Biff Microsoft Excel MVP "Fritz" wrote in message ... Sorry, I'm a bit of a neophyte at this...having trouble understanding this...can you help me? "T. Valko" wrote: See if this helps: http://contextures.com/xlFunctions02.html -- Biff Microsoft Excel MVP "Fritz" wrote in message ... Thanks very helpful...another question, if a user selects one of the items in the pull down list there is a unique number associated with that item which I would like to have displayed in another column...how do I accomplish that? "T. Valko" wrote: What type of pull down list? If it's from DataValidation disable the error alert message. Select the cell with the drop down list Goto the menu DataValidation Select the Error Alert tab Uncheck: Show error alert..... OK -- Biff Microsoft Excel MVP "Fritz" wrote in message ... If I have built a pull down list, how do I add the ability to also add free form content to the chosen cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
populate fields based upon pull down lists | Excel Worksheet Functions | |||
How do I update the built in header and footer pull down lists? | Excel Discussion (Misc queries) | |||
Creating Pull Down Lists in Excel cells. | Excel Discussion (Misc queries) | |||
Pull down lists | Excel Discussion (Misc queries) |