Hi, i am new to this group and am a relative beginner without formal
training. I've created an invoice for work and I have one column with a
dropdown list that I created using the great info from:

http://www.contextures.com/xlDataVal01.html

What I am trying to do is enter a billing code which is a number several
digits long. I was able to create this using the data validation function.
However, it requires the user to remember which billing code to use. Each
code has a descriptive name (very easy to remember) but it is not necessary
to put that name in the invoice, only the code number. I would like the
dropdown list to contain the descriptive name, but when you select the name,
instead of the name being entered in the cell, it enters the code number.

For example, the code for "repair" might be "3A245134", it is easier to
remember "repair" than the number. So, from the dropdown list, one of the
selections would be "repair". You select repair and the number "3A245134"
appears in the cell.

Is there a simple way to do this?
--
Thanks for your help
Russ