I don't know what a "dv cell" is per your request. (...have them both show up in a dv cell)
However, if what you want is to have another cell return a numeric value based on the linguistic return of the validation choice, do this:
Create your list of linguistic choices in one column (say K), in the next column (J) enter the corresponding numeric value for each choice.
In the cell next to your validation cell, enter the following formula:
=VLOOKUP(A1,$K$1:$L$4,2,1)
where A1 is the validation cell, K1:L4 is the range of linguistic and numeric values. Of course, I prefer to name my table ranges, e.g. "Table1", and the formula would look like this:
=VLOOKUP(A1,Table1,2,1)
Does this work for you?
Bookmarks