drop down shows one value but inputs an alternate value

[timber]

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!!!

[davesexcel]

you could use a lookup formula, maybe give a little more info so somebody can post an example for you

[Debra Dalgleish]

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

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