You can either use a lookup table with to had the dropdown box's value
translated,

Example:
=LOOKUP(A2,$D$2:$E$5)

or if you want to be more flexible and use any number, you could see this:
http://www.ozgrid.com/VBA/ValueToWords.htm
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"- pat" wrote:

Hey all,

I am using excel 2007 on XP Professional SP2. I am using a drop down
box on a worksheet that selects from a column of designated data
elsewhere on the worksheet. The data I have is 1 row of codes, with 1
row of descriptions for that code. I would like to select a code in the
drop down box and have the corresponding description fill in an adjacent
cell to the drop down box. Is this possible?


Example


Codes Description
1 One
2 Two
3 Three
4 Four
etc...


When code '1' is selected in the drop down box for cell A1, I want cell
A2 to populate with 'One'. A2's data of course is based on what is
selected in A1.


Thanks.

-psnell
.