Best Way To Substitute Text From Drop Down List?

I have a list of approximately 100 products that I would like to give users a dropdown list to select from BUT while I want the list to show the product name I need the value placed into the cell to be its 5 to 7 character product code.

Seems like something that should be possible but would really appreciate some direction in how to go about it.

Thanks,