View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] BigFish311@gmail.com is offline
external usenet poster
 
Posts: 4
Default Drop Down list with Code Description

I was looking for a way to show a code description when choosing from
multiple values in a single cell.

Example

I have these codes and their definitions in a spreadsheet
A - Architecture
C - Civil
E - Electrical

I only see the following below to choose from in my list which might
not be a big help for some people.
A
B
C

I only want to see A show up in the cell but I would like to see "A -
Architecture" show up in the drop down list.

Can this be done?

Thanks