drop down list help

[iamgman]

Hello everyone, I am looking for drop down list help.....I know how to do the actual list (data/validate/list etc...) what I am wondering is can I have a word in the list and when it is selected have it display a number? here is my example:

It is for a work time sheet. At work we have multiple "work areas" that have to be filled out on each time sheet. for example, Terminal 1 is work area 3423, Terminal 2 is work area 3424 etc. SO I created a drop down list to list these areas.

What I want to do is have "Terminal 1" in the drop down list but have its number (3423) appear when selected.

Hopefully my question is not too convoluted.


Thank you in advance....

G

[NBVC]

You can't really easily overwrite the word with the number, but you can have another cell, say an adjacent cell, populate with the number...if that is okay?

If so, then you would create a table on the side somewhere.. probably right where the list is that you use to populate the data validation.. and in the next column put all the associated numbers... then use Vlookup() to extract..

so if the drop down is in A1 and the list is in, say X1:Y10

then =Vlookup(A1,$X$1:$Y$10,2,FALSE) would extract the approprate number for the selection made.