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
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.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks