| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validation List - Word and Numeric Association
I'm having a little difficult figuring out how to implement a validatio list in a worksheet I am developing. I have a cell that should have a validation or drop-down list with onl 5 choices. For example, the validation list would display words (ie Premium, Elite, Superior, etc.), but once the word is selected it ha to correspond to a static numeric percentage that is used for calculation at other locations in the spreadsheet. The word still needs to appear in the cell, however, the static numeri percentage associated with it's partner word must be th hidden/background result when it's partner word is selected. The list consists of the following and in two columns Static Loss Pools ============ Premium 0.69% Elite 1.18% Superior 1.67% Preferred 2.72% Classic 4.09% Thanks in advance for any guidance -- C.M. Weave ----------------------------------------------------------------------- C.M. Weaver's Profile: http://www.excelforum.com/member.php...fo&userid=2598 View this thread: http://www.excelforum.com/showthread.php?threadid=39351 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dropdown list data validation - word wrap | Excel Discussion (Misc queries) | |||
| Data Validation List - Dependant based on numeric values | Excel Discussion (Misc queries) | |||
| Use word to associate an item in validation drop down list | Excel Discussion (Misc queries) | |||
| Validation numeric and text | Excel Discussion (Misc queries) | |||
| Association/registration problem with Word and Excel files. | Excel Discussion (Misc queries) | |||
Threaded Mode
