Two column drop down box

How do I set up a two column drop down box that stores only one value in a row in a cell?

For example the Curriculum is Math and the code is M. I want the M to be the value in the cell but the drop down shows both the code, M, and its corresponding curriculum Math.

Can anyone help me?

Thanks!

Veronica Boaz

Oldchippy:

I don't think Veronica needs a dependent validation. Instead, she needs to store one value but have two values appear in the dropdown selection.

Veronica:

The best way to do this (in my opinion) is to use a combo box from the control toolbox. Of course, this requires a minimal amount of VBA usage. If you are OK with that, post back with a sample of your worksheet, and we can set something up for you.

(See example below)

You have it exactly right. I want it to store one value and display two.

I have attached the template. This is an import worksheet. I have to import the code but no one knows all the codes so I want to display the description.

I have attached the zip file. You're saving my life!

A list of the current curriculum codes and descriptions must be placed somewhere within the file. You can either have another sheet attached and used for reference, or you can place them within the sheet itself and hide those columns. How would you prefer to procede?

I can put the list on another sheet in the workbook.

Can you walk me through it? The combo box example you sent me is exactly what I need.

Thanks so much!

Steps to populate a combobox with two columns of information:

1. Place a combo box onto your spreadsheet from the control toolbox (to access the control toolbox, in the main toolbar, go to VIEW-TOOLBARS-CONTROL TOOLBOX).
2. While in design mode, right click on the combobox and select PROPERTIES. A dialog box should appear.
3. You must change three of the properties:
a. ColumnCount should be 2 (displays 2 columns)
b. LinkedCell: whereever you want the selected value to be displayed. If you want to display the value in Sheet1, cell G1, then enter Sheet1!G1.
c. ListFilRange: the values to display in the combobox (ie, Sheet2!A2:B10)

Let me know if any of this helps you.

Unfortunately, I do not know of any way to be able to click a cell reference. Working with activex controls is not always the most efficient process.

See example