Drop down list and validation question

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
Mon Oct 10 09:48:30 CDT 2005

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@yahoo.com wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

brewman_63
Mon Oct 10 13:45:17 CDT 2005

Thanks. This worked.