You could do this with programming. There's a sample workbook on my web
site that shows a product name and code in the Data Validation dropdown
list. After an item is selected, the cell shows only the product name.
You may be able to adapt this to your workbook.

On the following page:

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

Under the data validation heading, look for 'Data Validation "Columns"


cmk18 wrote:
> I have a survey where users score things on a linguistic scale (e.g.
> Very Satisfied, Satisfied, etc.) and I want to convert that to a
> numeric score, but still keep the Linguistic Value. I was hoping there
> was a way to have a cell with the linguistic value and the a cell with
> the numeric score, but have them both show up in a dv cell.
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html