Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down menu ( list)
I have made a drop down list to select different (text) names. Is there a way
to make each name correspond to a different number and place that number in a different cell For ex. Cell # A1 Cell # A4 Chad 2 Nick 12 Jason 118 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down menu ( list)
Use a lookup table
=IF(A1="","",VLOOKUP(A1,$K$1:$L$20,2,0)) where you would create a 2 column table with the list you are using in the left column and the numbers in the right column In my example I used table in $K$1:$L$20 you obviously need to have this in another cell as opposed to in the cell with the dropdown -- Regards, Peo Sjoblom "Chad" wrote in message ... I have made a drop down list to select different (text) names. Is there a way to make each name correspond to a different number and place that number in a different cell For ex. Cell # A1 Cell # A4 Chad 2 Nick 12 Jason 118 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down menu ( list)
Hi,
For more information, please refer to this URL: http://www.contextures.com/xlDataVal02.html. Note: At the end of this page there are for more information corresponding to list. Challa prabhu "Chad" wrote: I have made a drop down list to select different (text) names. Is there a way to make each name correspond to a different number and place that number in a different cell For ex. Cell # A1 Cell # A4 Chad 2 Nick 12 Jason 118 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The drop down menu of my validation list needs to display more. | Excel Discussion (Misc queries) | |||
Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions | |||
List (Drop Down Menu) Scroll Bar | Excel Discussion (Misc queries) | |||
How do I set up a drop-down menu/list in Excel? | Excel Worksheet Functions | |||
How do I set up a drop down menu for a validation list? | Excel Worksheet Functions |