I am trying to create codes into a drop box (I figured out how to do this in
the data validation tab) and have these codes appear as a number in another
cell. does this make sense, and can this be done? Please Help!!!

Thank You!!!!!!