I need to create a pick list in a very small cell that is large enough for 3 characters, which represent departments. but the list i need to show the full department name when they scroll to select.

example.

123 - shipping
abc - sales


when they click the cell the drop list would show shipping and sales. If they selected sales the cell would then populate with abc, if shipping it would show 123.

total newb and sure i'll have more tonight :-)