Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Complicaded Drop down list
Is there any way of having a drop down list such as the following:
System count wrong Customer requested more than we normally stock Out of stock Item not on L.I.T.E list Not a normal stock item for your branch Vendor Supply Problem but when ones of these are selected for a corresponding value show up in place of it. As per following 100 = System count wrong 200 = Customer requested more than we normally stock 300 = Out of stock 400 = Item not on L.I.T.E list 500 = Not a normal stock item for your branch 600 = Vendor Supply Problem |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Complicaded Drop down list
I think I'd use an extra cell (directly to the left of the cell with the
dropdown). And I'd build a separate worksheet that had the descriptions in column A and the number codes in column B. If that dropdown is in B1, then I'd put this in A1: =if(b1="",vlookup(b1,sheet2!a:b,2,false)) Savage wrote: Is there any way of having a drop down list such as the following: System count wrong Customer requested more than we normally stock Out of stock Item not on L.I.T.E list Not a normal stock item for your branch Vendor Supply Problem but when ones of these are selected for a corresponding value show up in place of it. As per following 100 = System count wrong 200 = Customer requested more than we normally stock 300 = Out of stock 400 = Item not on L.I.T.E list 500 = Not a normal stock item for your branch 600 = Vendor Supply Problem -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |