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