Multiple Cells Filled From One List Box

Here's what I want to do:

I want either a combo or list box in cell "A2" to list one of several selections full names, i.e., "Compact Disc, Cassette, etc." When you select the full name it returns it's abbreviation, i.e. "CD, CAS, etc." in the same cell "A2," and also returns it's catalog number in B2 and the label in C2.

In this example CD and CAS are obviously short for Compact Disc and Cassette, but not all the codes are that obvious, which is why I require the translation.

I have a second worksheet titled "data" with an array of data that's particular to a given selection. The list of selections run down a column while the selections data runs across the rows.