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

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

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

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