I have a drop down list of 7 phrases. How can I assign a value(1-7) on
each list so it will reflect to next cell?
Lets say the dropdown is in B2 and I want its value in C2.

Thanks.


--
cardingtr
------------------------------------------------------------------------
cardingtr's Profile: http://www.excelforum.com/member.php...o&userid=27027
View this thread: http://www.excelforum.com/showthread...hreadid=513899