drop down list

[ML]

Hello
Through Data > Validation, I've created a drop down list for a column to
enable the user, when going into the cell , to choose what is listed. They
are 3 letter codes. ie.
RCC | Royal Caribean Cruise line
RML | Royal Mail
PCC | Portsmouth City Council
When clicking on the down arrow in the cell and seeing the list of codes, is
there a way of also being able to see what the code relates to which i've
put in a colum along side the colum containing the list of Codes.so that if
you don't know the code of the company you can see it in the list and pick
it but only the code shows in the cell
I hope that made sense.
Thank you

 

[bc]

Hi
Sounds like a job for a Combo Box with the Column Count set to 2
Brian

 

[T. Valko]

There is a sample file here:

http://contextures.com/excelfiles.html#DataVal

Look for: DV0005 - Data Validation "Columns"

 

[ML]

Thanks I'll give it a go
J

There is a sample file here:

http://contextures.com/excelfiles.html#DataVal

Look for: DV0005 - Data Validation "Columns"

 

[T. Valko]

Good luck. Thanks for the feedback!

 

[ML]

It was perfect
Thank you very much

Thanks I'll give it a go
J