You can do this with programming. There's a sample file he

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

Under Data Validation, look for 'Data Validation "Columns"'

timber wrote:
I would like to build a drop down menu that shows one value (ie the name) but
the value that is inputted in the table is the matching number to that name.
Does anyone have any idea how to do this.

My drop down lists are listed in the same file but a different worksheet
then where the data is entered.

Thanks!!!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html