Excel List
 

Using the list option from Excel: Data-Validation. Is there a way to have
different display and data values in the list.

Excel List
 

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"

Excel list-display and data values wrote:
Using the list option from Excel: Data-Validation. Is there a way to have
different display and data values in the list.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Excel List
 

See this:

http://contextures.com/xlDataVal02.html

Biff

"Excel list-display and data values" <Excel list-display and data
wrote in message
...
Using the list option from Excel: Data-Validation. Is there a way to have
different display and data values in the list.

Excel List
 

Thank you Debra,
This has worked.

"Debra Dalgleish" wrote:

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"

Excel list-display and data values wrote:
Using the list option from Excel: Data-Validation. Is there a way to have
different display and data values in the list.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html