Hi,
You could use VLOOKUP to display description in adjacent column to
Code entry.

Code in Column A, Description to be placed in B, then in col B - starting
row 2, put:

=F(iserror(vlookup(A2,MyTable,2,false)), " ",vlookup(A2,MyTable,2,false))

where "MyTable" is named range containing Code and Description.

Copy down in column B.

HTH

"Alex" wrote:

I've highlited a column and put a validation having the range in a different
spreadsheet. In the spreadsheet with the range I have to columns - Code and
Description. But, for the validation I'm using only the first Code column for
data entries.
The validation is working well but a user entering Code can see only Code.
It would be nice to show the user the Description as well - not for entries
but just to see the Code's description.

How could I show the user the second column?