On worksheet1 I have a list of codes in named range A1 to A6. In column B1 to b6 I have a description of each of these codes. On worksheet 2, When the user selects cell E2, I want a drop down list pointing to both columns A and B to display the codes and the explanations. However, when the code is selected, I want ONLY the code to appear in the cell E2. Because cell E2 is narrow, only wide enough for the 2 digit code, How can I display the explanation along with the code? How can I pick up only the 2 digit code for insertion into the cell? Can this be done?