Not sure even how to phrase this question, and not sure whether this should
be handled programmatically, or with some existing function in excel, but
here goes:

I need to create a drop down box that actually presents two items on each
"row" of the dropdown, but when the user selects one, it returns only on
value (say, first one). Example combo box:

CLASS A This project is a complex project that will last more than 1 year
CLASS B This project is a medium complex project that will last < 1 year
CLASS C This is a relatively simply project lasting less than 1 year.

In the above, I want the user to see the description portion of the drop
down, as well as the CLASS "X" result, which is what I really want to
capture. If they had selected the first item I would want to see CLASS A in
that cell (not the description).

This make any sense? Does this need to be handled with a function of sorts
or must I program this. If the latter, any suggestions on easiest approach?

Thanks!

pat