View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Spongebob Spongebob is offline
external usenet poster
 
Posts: 13
Default Can I add a description column or alternate column in a validation

I am running a validation on a cell for a particular code to be used for a
timesheet. For the finished result I need just the code to show up in the
cell, however there are quite a few codes and they are difficult to remamber.
Is there a way to have the drop-down list display the description (S -
Schematic Design) but then have the result of the drop-down be just the code
(S)?

Thanks in advance,
Jeffrey K. Ries