| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Validation List - Word and Numeric Association
Not sure what "hidden/background" means, but if the validation cell is in A1
and the 5 X 2 table you gave in your example is named "pool": Place in another cell: =VLOOKUP(A1,pools,2,FALSE) Name this array "pool": Premium 0.69% Elite 1.18% Superior 1.67% Preferred 2.72% Classic 4.09% Don Pistulka "C.M. Weaver" wrote in message ... I'm having a little difficult figuring out how to implement a validation list in a worksheet I am developing. I have a cell that should have a validation or drop-down list with only 5 choices. For example, the validation list would display words (ie. Premium, Elite, Superior, etc.), but once the word is selected it has to correspond to a static numeric percentage that is used for a calculation at other locations in the spreadsheet. The word still needs to appear in the cell, however, the static numeric percentage associated with it's partner word must be the 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. Weaver ------------------------------------------------------------------------ C.M. Weaver's Profile: http://www.excelforum.com/member.php...o&userid=25986 View this thread: http://www.excelforum.com/showthread...hreadid=393515 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Validation List - Word and Numeric Association
Sorry, should be: =VLOOKUP(A1,pool,2,FALSE) pool not pools "Don" wrote in message ... Not sure what "hidden/background" means, but if the validation cell is in A1 and the 5 X 2 table you gave in your example is named "pool": Place in another cell: =VLOOKUP(A1,pools,2,FALSE) Name this array "pool": Premium 0.69% Elite 1.18% Superior 1.67% Preferred 2.72% Classic 4.09% Don Pistulka "C.M. Weaver" wrote in message ... I'm having a little difficult figuring out how to implement a validation list in a worksheet I am developing. I have a cell that should have a validation or drop-down list with only 5 choices. For example, the validation list would display words (ie. Premium, Elite, Superior, etc.), but once the word is selected it has to correspond to a static numeric percentage that is used for a calculation at other locations in the spreadsheet. The word still needs to appear in the cell, however, the static numeric percentage associated with it's partner word must be the 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. Weaver ------------------------------------------------------------------------ C.M. Weaver's Profile: http://www.excelforum.com/member.php...o&userid=25986 View this thread: http://www.excelforum.com/showthread...hreadid=393515 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Validation List - Word and Numeric Association
This example works if the Static Pool Name (ie. Premium, Elite, etc.) is in one column (A1) and it's corresponding Static Pool Percentage (ie. 0.69%, 1.18%, etc.) is in column B1?, correct? -- C.M. Weaver ------------------------------------------------------------------------ C.M. Weaver's Profile: http://www.excelforum.com/member.php...o&userid=25986 View this thread: http://www.excelforum.com/showthread...hreadid=393515 |
| Reply |
| 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) | |||
Hybrid Mode
