Drop down list and validation question

[brewman_63]

I'm not sure if what I want to do is possible with Excel '03. Here's
what I would like to do:

I have a list that consists of 2 columns in a spreadsheet (ex. Country
Codes and Description). The list looks like this:

Column A Column B

US United States
GB United Kingdom
MX Mexico

etc.

In another sheet in the same workbook I would like to have a drop-down
list show either both columns (US - United States) or just the
description from column B (United States). Depending on what the users
selects the code from column A is put in the cell (US for United
States).

Is there a way to do this?

Thanks.

 

[Debra Dalgleish]

You could do this with programming. There's a sample workbook on my web
site that shows a product name and code in the Data Validation dropdown
list. After an item is selected, the cell shows only the product name.
You may be able to adapt this to your workbook.

On the following page:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for "Data Validation Columns"

 

[brewman_63]

Thanks. This worked.