Excel List

  • Thread starter Excel list-display and data values
  • Start date
E

Excel list-display and data values

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

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"
 
E

Excel list-display and data values

Thank you Debra,
This has worked.

Debra Dalgleish said:
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"
Click to expand...
 
Top