Hi,

You can achieve this with this too..

1. In a column which will never be accessed by anyone else. Let this be
hidden.
2. Write a formula to concatenate the two values. Say,

=A1&" --- "&B1

3. Copy down till you need the two values to be concatenated.
4. Name the list Insert/Name/Define
4. Make a dropdown list which is named by you just now.

Hope this will help you.


Thanks,

Shail

wrote:
I have a validation on a cell which is bringing a list of code numbers. At
the same time in the same cell, I will like the names related to this codes
to show for users to be able to identify the name of these codes. How can I
do this?

Example:

List of codes Name of codes
15 Human Resource
33 Training

On the validation cell right now the list of codes is showing up, I want to
have the name of these codes showing as well when people are choosing the
code.