drop down shows one value but inputs an alternate value
 

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

drop down shows one value but inputs an alternate value
 

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


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=530248

drop down shows one value but inputs an alternate value
 

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