Thanks a lot Toppers.
But, I wouldn't like to enter the data from the Description column. I'd like
just to show it to the user during the Code entries as in MS Access for the
second (or more) not bound column in a combobox.

"Toppers" wrote:

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?